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

  • Thread starter Thread starter Fun In The Sun
  • Start date Start date
F

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
happening.
 
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.

Pete
 
Back
Top