Why do the zip codes starting with "0" in Excel format DROP the z.

G

Guest

When typing addresses with the zip code starting with a zero, why does it
drop it off?
 
G

George K

Don't have a clue, but if you live in Connecticut (06xxx) you run into the
same problem. Highlight the cell, goto Format> Cell>Number>Custom, in the
box labeled Type, enter 00000 (five zeros), then OK. Excel should display
the cell with a five digit number with a leading zero. Not sure, but if you
enter only the four significant digest, Excel may auto add the leading zero.
You can also format an entire row or column the same way.
 
N

Nick Hodge

Excel has little idea you want to type a zip code and as a 'number' excel
sees no need for a leading zero and strips it.

You can do as posted below or format the cells in advance as text
(Format>Cells..Number>Text) or precede the entry with a single apostrophe
('). It will not show but will keep the entry exactly as is

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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

lead zeros in zip codes show but will not print 2
How to enter zip starting with 0 (zero) 10
Zip Codes Dropping Leading Zero 3
how do I stop Access from dropping 0 on zip codes starting w/0? 2
Zip Code formatting problem 3
zip codes starting with 0 1
Saving a CSV file from Excel with 0 in front of Zip code 10
Format Zip Codes Correctly for a Mailmerge 3

Top