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. ...
It depends on what do you mean under "I down loaded a comma separated values spreadsheet to excel". If just double click on csv file to open it in Excel - no, where is no way to prevent such conversion, but you may vote for this idea here Stop Excel from changing large "numbers" (actually text values) to scientific notation. – Welcome to Excel’s Suggestion Box! (uservoice.com)
The only way is to assign text type to such columns during transformation. As AnaBoyko mentioned you may use Power Query or, alternatively, legacy From Text connector where assign text type on the third step of the wizard.