View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Reading CSV with numbers in text format, Excel automatically converts to scientific notation

"Fredy617" wrote:
I have a CSV file with numbers like 00425067891253.
They are formatted as text.

[....]
Is there any way to open these in Excel without the
numbers automatically converting to scientific format?


The problem is not the display in Scientific format so much. That would be
easy to remedy: simply change format to Number after opening the file.

(However, that might not be acceptable to you.)

The real problem is: Excel does not read the IDs as text if you open the
file directly in Excel. Excel reads them as numbers, even if you manually
enclose them in double-quotes.

Consequently, you "loose" the leading zeros. And worse: any numeric ID
longer than 15 digits will be modified, replacing the digits after the first
15 digits with zeros.

If all such numbers (and nothing else) are in columns, you can use the Text
Import wizard to read the CSV file into a blank worksheet instead of opening
the file directly. One of wizard options allows you to select the format of
an entire column as Text.