#INVALID OPERATION - Apostrophe catastrophe
I'm trying to convert some numbers expressed in KB into GB so I can sum all in GB. To do this I had to use the LEFT function to pull everything appended with "KB" from a column. That was no problem. I then took the result of that function and did a copy/paste special, so I would no longer have the formula, but the value. I then used another column to divide the KB by 1000000 in order to get GB. The result continues to be an #INVALID OPERATION error. I know it's not the syntax of the formula, because I can enter values manually and it works fine. Additionally, I've just noticed that there is a very small apostrophe preceding all of the numbers in the column where the #INVALID OPERATION error shows up.
In other words - if I overwrite the value in the column manually, it apparently gets rid of the unwanted apostrophe, and the formula works.
Question - why is the apostrophe showing up in the first place, and how can I easily rid myself of it so this formula works as expected? It must have something to do with the copy/paste special command I performed, but I've tried re-doing that in different ways, and still get the problematic apostrophe.
Help Article Resources
Check out the Formula Handbook template!