I want to keep leading zeros in my excel spreat sheet, How?

D

Dave Peterson

If you can see the leading 0's in excel, then after you create your CSV file,
don't import it back into excel to verify it.

Open that CSV file in Notepad--or your favorite text editor.

(Reopening in excel will lose those leading 0's--but they should be there in the
CSV file.)
 

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
Replacing cell numbers but leaving leading zero 1
Importing to Excel from csv AND keep leading zeros 2
How do I remove the apostrophe(') in front of zeros 3
Stop automatically removing leading zeros? 2
Add Leading Zeros 4
How do I stop Excel from dropping leading zeros? 9

Top