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

[Guest]

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 Format>Cells>Text also converts everything
to scientific notation

 

[Ragdyer]

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.