How do I preserve cell content when saving an excel file in csv
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.
--
Gary's Student
"beachwurm" wrote:
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?
|