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.
 

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
*.csv format change if .xlt save as .csv in Excel 2007 1
Excel CSV Files; Creating Of 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
CSV file 2
Unicode in CSV files 5
Saving double-byte characters as unicode text in a CSV file 4
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1

Back
Top