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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top