Home > Forum Home > Presenting and Reporting Data > Excel mistakenly formats as Scientific Notation Share

Excel mistakenly formats as Scientific Notation

Excel Help for Excel Mistakenly Formats As Scientific Notation in Presenting and Reporting Data


Forum TopicPost Reply Login

Excel Mistakenly Formats As Scientific Notation

Rate this:
(3/5 from 1 vote)
ConfusedHow do I turn off the auto formatting to scientific notation in Excel? Our users are receiving email attachments from a vendor’s mainframe in .csv format. The csv file has quotations around all text fields but this doesn’t help. When the users try to open the file, it automatically formats some of the data as scientific notation. The data being corrupted is either a FedEx tracking # like "006854230175290" or a vendor’s part number that has an E in it like "0636107208E001". Has anyone found an option in Excel or registry key that disables auto formatting to scientific notation when opening a csv file?
Thanks
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
In the case of a part number that has an E within numbers like "0636107208E001",  Excel changes the value it stores when it is opened, so even if you change the format of the cells you can never get the original csv data back.
The users are double-clicking on an attachment to an email. We are not going to be able to get them to save the file first and them import it into Excel. This only happens once in a while, it is not with every csv file that they get, only if it contains certain data.
Since they never have a use for scientific notation (or even know what it is), I was wondering if anyone had found a way to disable Excel ever converting data to scientific notation.
 Posted by on
Oops
Rate this:
(3/5 from 1 vote)
Have you tried to format the columns in question as a number after opening the CSV file?

Alternatively, you could use the import wizard Data > Import External Data or write a macro which does the same thing for your users.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Excel mistakenly formats as Scientific Notation in the