Converting numbers and number formatting to a CSV file ?

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

Guest

Is there a way to convert cells with numbers to a CSV file and keep the
formatting??

I have a file with a list of 50+ items that are over 12 digits each . .
..when I save it in as a CSV file it defaults to the Scientific Exponential
Notation (Ex: 9.78E+12) and loses any Excel formatting. Is there any way to
keep the number formating and save it as CSV? I tried saving it as text and
then as CSV but that didn't work.

Any ideas?

Thanks so much for your help!
 
If you save as .csv and look at the .csv file with Notepad, you will see no
conversion. If, however, you re-open the .csv file with Excel, Excel will
convert to Exp. format.

Just re-name the file .txt rather than .csv, Excel will then bring up the
Wizard and you can specify the field as Text.
 
Back
Top