I have a column in spreadsheet. It has a (') in front of each number '006040001
When I use the find and replace with a space it turns only some of the numbers into something that looks like a formula that looks like this 9.9502E+17 instead of the number.
I tried formatting the column as text and I also tried formatting the column using copy, paste value only.
In both cases I still get this on some of the numbers. If I click on it the real numbers do come back but I need this to just be a text value as I am using it for a naming convention. The number were generated by a program I have no control over.