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

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

Pete_UK

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
 

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
problem when saving CSV file 1
Keeping lead zeros in excel text format when saving as CSV file 1
Import .csv File Problems 5
CORRECTION - Leading Zero's 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Leading zeros lost in csv 2
Leading Zeros - CSV File 6

Top