Leading zeros lost in csv

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text column in Excel where numbers are stored like 001 or 001a.
When I save the file as csv, it deletes the leading zeros on the ones that
are like 001.

Any ideas?

Thanks in advance for your help!

Liz
 
Liz

Open the CSV file in Notepad or Wordpad to see the leading zeros.

If you re-open in Excel, you lose the leading zeros.


Gord Dibben MS Excel MVP
 
Instead of verifying that the leading 0's are there using excel, open the .CSV
file in notepad.

It's not the saving of the .CSV file that gets rid of the leading 0's. It's the
reopening in excel that removes them.
 

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

Open CSV as txt data 5
How to prevent leading zero's from being dropped from a CSV file 1
Cocatenate not showing leading zeros MS Excel 2003 6
Keeping lead zeros in excel text format when saving as CSV file 1
zero supress leading zeros when chg format from text to number 4
Excel time leading 1st ZERO 3
leading zero & .csv files 4
Keep Leading Zeros in Concatenation 5

Back
Top