Thread: Reading CSV with numbers in text format, Excel automatically convertsto scientific notation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fredy617 Fredy617 is offline
external usenet poster
  
Posts: 2
Default 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?
Reply With QuoteReply With Quote