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

Excel formats as Scientific Notation

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


Forum TopicLogin

Excel Formats As Scientific Notation

Rate this:
(3/5 from 1 vote)
ConfusedIn 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
 
View Full Post

Excel templates and solutions matched for Excel formats as Scientific Notation:

Solutions: Database Conversion Database Report Builder Database Format Converter SQL Database Converter Export PowerBuilder DataWindow DBF Converter Upload to Database Compatible Alternative Contract Templates Flash Book Creator Organizational Chart Template