How to prevent leading zero's from being dropped from a CSV file


Fun In The Sun

I have an excel spreadsheet that is formatted into a CSV file. When the CSV
file is created, the leading zeros are dropped. How can I prevent this from


Open the CSV file using Notepad to check if the leading zeros are
there. If they are, then rename the file to have an extension .txt,
then from within Excel do File | Open - the Data Import Wizard will
start automatically, and here (on the 3rd panel) you can specify which
fields you want to be treated as Text.

Hope this helps.


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