Converting numbers and number formatting to a CSV file ?

C

Cecilia

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

Gary''s Student

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.
 

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

Adding data to MS Access from csv file 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
Inconsistent formatting of section numbers 0
How can the font and size of (all) citation numbers be altered? 1
numbers convert to formula in csv 2
CSV files and having numbers and strings in there... 9
bank transfer error numbers display from workbook to csv 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1

Top