My god, I was just using a reference table on another sheet to drive a few columns of data in my first sheet (basically a color hex code in the main sheet that would match a code in the reference table and return the color name in one column and a part size in the next one) and for some unknown reason, 3 rows of the reference table were causing an N/A (value not found) error in the first sheet.
I checked every variable I could think of and nothing was solving the issue.
Finally tried literally retyping the same damn value in the cell and it instantly fixed the issue. There weren’t any extra spaces, format never changed…it just really needed me to retype it.
Silly me went and learned VBA code to make excel work right. … and whose idea was it to have default paste, paste the format?!? When has anyone EVER wanted a table filled with different sizes and colors and fonts. Make the formatted paste the ctrl-shift-v if you want that so bad. JfC. Am i not being rational? Because this gets me HEATED.
Pasting with format as default is one of the biggest mistakes of humanity. I can’t remember a single situation in all my life that I needed this.
My favorite is writing an email, copy&pasting a name and send it to the person. Only to discover later (on a different device) that your stupid email program pasted with format without actually showing it to you. And your mail looks like some moron played with the format settings.
You can change whole row/columns to a different number default to stop it.
Make it assume decimals, dollars, dates, even SSN formats.
You can format cells to do any number of crazy things, but damned if I don’t occasionally run into something that simply refuses to take my setting.
My god, I was just using a reference table on another sheet to drive a few columns of data in my first sheet (basically a color hex code in the main sheet that would match a code in the reference table and return the color name in one column and a part size in the next one) and for some unknown reason, 3 rows of the reference table were causing an N/A (value not found) error in the first sheet.
I checked every variable I could think of and nothing was solving the issue.
Finally tried literally retyping the same damn value in the cell and it instantly fixed the issue. There weren’t any extra spaces, format never changed…it just really needed me to retype it.
Sometimes you have to save and close to show Excel you mean business…
It’s a dominance thing
Silly me went and learned VBA code to make excel work right. … and whose idea was it to have default paste, paste the format?!? When has anyone EVER wanted a table filled with different sizes and colors and fonts. Make the formatted paste the ctrl-shift-v if you want that so bad. JfC. Am i not being rational? Because this gets me HEATED.
Pasting with format as default is one of the biggest mistakes of humanity. I can’t remember a single situation in all my life that I needed this.
My favorite is writing an email, copy&pasting a name and send it to the person. Only to discover later (on a different device) that your stupid email program pasted with format without actually showing it to you. And your mail looks like some moron played with the format settings.
I want NAMES!!
Interesting. What SSN would you use though, as an example? What would the numbers be?
123456789 to 123-45-6789
Like that?
Lol no. I was being silly, acting like I wanted thier ssn.