Leading zeros lost in csv



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!


Gord Dibben


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

Dave Peterson

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