CSV file dropping lead zeros

T

tshad

I have a CSV/Txt file that I am opening and I tell it that it is tab
delimited.

I find that my first columns, that have numbers in them, are dropping the
leading 0's. I don't want that. I need the leading zeros.

How do I tell excel not to do this?

Thanks,

Tom
 
D

Dave Peterson

Use NotePad to look at your .csv file.

I bet the leading 0's are lost when you re-import into excel.

If you have to reimport into excel, you can rename the .csv file to .txt. Then
when you open the text file, you'll see the data|text to columns wizard. You
can specify the format of each field--including Text for those fields that have
to have the leading 0's.
 

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
Display leading zeros 2
csv import into excel, preserving leading zeros in numbers 1
Open csv file with Leading Zeros 1
Importing via a text or csv file 3
csv format drops ending zeros 2
Converting .txt file to Excel 1
Losing leading 0 when saving as .csv 2

Top