Home 
Search 
Today's Posts 
#1




How do I stop Excel 2007 from using scientific notation?
I need to stop Excel 2007 from changing a location code (38E2) to scientific
notation. This file needs to be in a CSV format. I have formatted the cell as TEXT and tried using the single quote before the data ('38E2). Each time i reopen the CSV file, any cell with that same format (xxEx) turns back to scientific notation. (Ex. 38E2 3.80E03, 42E2 4.20E03, etc) 
#2




How do I stop Excel 2007 from using scientific notation?
If you've got a text value of 38E2 in the cell, that will be what is in the
CSV file. You can check by reading the CSV with something like notepad. The problem arises if you open the CSV with Excel and allow Excel to decide how to interpret the data. Rather than just opening the CSV with Excel, if you want to read it with Excel, use what in Excel 2003 is the "Data/ Import External Data ..." feature, which allows you to specify that the relevant columns should be read as Text, not General format. I understand that the Excel 2007 equivalent is "Data/ Get External Data ...".  David Biddulph "jonnyjd" wrote in message ... I need to stop Excel 2007 from changing a location code (38E2) to scientific notation. This file needs to be in a CSV format. I have formatted the cell as TEXT and tried using the single quote before the data ('38E2). Each time i reopen the CSV file, any cell with that same format (xxEx) turns back to scientific notation. (Ex. 38E2 3.80E03, 42E2 4.20E03, etc) 
#3




How do I stop Excel 2007 from using scientific notation?
You'd get the same seeming bad behavior out of Excel 2003 also. You may have
noticed a warning that "some features" of your workbook were incompatible with the CSV file format. Excel was just trying to hint that you were going to have this problem when you open the file later on. One way to deal with it, perhaps not the answer you were looking for, is to open a new workbook and then use Data  Import External Data and then select the group with .csv and .txt file types in it and work through the definition of the import process, and at one point you can tell it that the column for that group is to be imported as TEXT!! not converted to scientific notation. Hope that helps at least a little. "jonnyjd" wrote: I need to stop Excel 2007 from changing a location code (38E2) to scientific notation. This file needs to be in a CSV format. I have formatted the cell as TEXT and tried using the single quote before the data ('38E2). Each time i reopen the CSV file, any cell with that same format (xxEx) turns back to scientific notation. (Ex. 38E2 3.80E03, 42E2 4.20E03, etc) 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Excel reading pasted values as Scientific Notation  Excel Discussion (Misc queries)  
HOW DO I STOP AUTOMATIC SCIENTIFIC NOTATION IN A CELL  Excel Discussion (Misc queries)  
Scientific Notation  I want excel to read it as a text not a numb  Excel Discussion (Misc queries)  
Excel 2003 won't let me change Xlabels from scientific notation  Charts and Charting in Excel  
scientific notation to display 1.8 x 105 in Excel  New Users to Excel 