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

Excel converts 9-digit string to sci. not. when saved as csv
 

If the cell is formatted to General, and the number is too large to fit in
the cell, you'll get that scientific notation.

If the cell is *pre*-formatted to Number, your long numbers will either
enlarge the column to accept all the digits, OR give you the #### signs.

You shouldn't get scientific notation in any case.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"epen" wrote in message
...
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