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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to resolve incompatibility of saving an excel to csv format 1
CSV to Excel 3
CSV text data altered on file open 4
EXCEL read a text string as scientific notation 7
how can I save an excel file with long number columns in cvs form. 3
keep cell as text, not number 2
Import large number string 1
Modification of a .CSV file 6

Back
Top