Leading zeros in CSV and Excel 97

L

Leslie

Hi,
Is there any way to import a CSV file that contains
leading zeros into Excel 97? No matter what I do, it
drops the leading zeros. If I open it in Notepad, the
zeros are there, but not in Excel.

Any ideas?
Leslie
 
D

Dave Peterson

If you rename the .csv file to .txt, you can open it and tell the text import
wizard to treat that field as text.

(or you could apply a custom format after you import the file (like 00000 to
show 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

How to stop Excel from automatically truncating leading zeros 2
Open csv file with Leading Zeros 1
Importing to Excel from csv AND keep leading zeros 2
Loosing Leading zeros in CSV file 2
Stop automatically removing leading zeros? 2
How do I stop Excel from dropping leading zeros? 9
Converting xls to CSV file - dropping leading 0s 1
How do i save a csv file to keep leading zeros please? 4

Top