View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
epen epen is offline
external usenet poster
 
Posts: 1
Default Excel converts 9-digit string to sci. not. when saved as csv

When using data in MS Excel, I frequently have a column with length 9 string
of all digits. If I want to export to Access or save as a *.csv, Excel
converts this to scientific notation and it cannot be converted back to the
original data.

I often have rows of 1100 or more, so manually entering a single quotation
mark at the beginning of each cell is out of the question.

Is there a way to turn off this conversion to scientific notation?
Highlighting the column then nsing FormatCellsText also converts everything
to scientific notation