Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation
I have a CSV file with numbers like 00425067891253. They are formatted as text.
No special characters can be inserted into these numbers as they as used for batch processing and the leading zeroes must be there. Is there any way to open these in Excel without the numbers automatically converting to scientific format? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening text file converts numbers to scientific notation | Excel Discussion (Misc queries) | |||
Excel reading pasted values as Scientific Notation | Excel Discussion (Misc queries) | |||
large numbers as text replaced with scientific notation | Excel Discussion (Misc queries) | |||
Hex numbers displayed in scientific notation when importing text f | Excel Discussion (Misc queries) | |||
Scientific Notation - I want excel to read it as a text not a numb | Excel Discussion (Misc queries) |