Forum Discussion
scientific notation forcing itself into my sheet
I down loaded a comma separated values spreadsheet to excel. One column is upc codes. many codes in it were converted to scientific notation upon download. I saved the file as an excel spreadsheet. ...
Depends on what do you plan to do further. If you just want to see these zeros and the nuber of digits in your data is the same, you may solve it with format.
But if you plan to do some calculations with these data, you need to re-download your data into the colomn pre-formated as text or use Power Query to download.