View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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)