Converting numbers and number formatting to a CSV file ?

[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!

 

[Guest]

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.