| 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? |
| 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) | |||
Threaded Mode
