How do I get Excel not to erase a leading Zipcode zero (eg 0xxxx)

G

Guest

I am creating an address list in Excel. The field for zipcodes will not
allow me to type in a Zipcode when the first number is a zero. The zero is
erased by Excel when I go to the next address line.
 

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

trying to insert a 0 in front of zipcode 2
Leading Zero 11
Need to add character before leading zero in a field 7
The zipcodes in my contacts drop the leading zero. How to fix? 1
leading zero not displaying 1
Leading Zero dropping off after export to Excel 3
leading zero & .csv files 4
How do I add an apostrophe in front of existing column in Excel? 2

Top