How do I preserve cell content when saving an excel file in csv

G

Guest

I am saving an excel spreadsheet in a Comma Delimited format. And when I do
it changes some cell information. Specifically I have a column of ID numbers
"00200030" that is changed to "200030". Is there any way to preserve the
"00" prefix in the csv format?
 
G

Guest

The trick is not in saving, its in re-opening:

Let's say you format A1 as Text and enter 01 in it. Save as .csv and exit
Excel. Right-click the .csv file and open with NotePad and you will see the
leading zero. If you re-open the .csv file with Excel, it will discard that
leading zero. So:

Once you have created the .csv, re-name it to .txt

If you tell Excel to open a .txt file, it will display the Import Wizard.
You can tell the Wizard that the field is 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

how do I change a csv extension file to an xls file and use it? 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
*.csv format change if .xlt save as .csv in Excel 2007 1
CSV file 2
Excel CSV Files; Creating Of 3
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1
Unicode in CSV files 5
Importing Excel file into Outlook 1

Top