how do i keep zip code zeros from disappearing

G

Guest

Excel 2003 Have tried formatting the column/cells in special format for
zips - no go
Tried text format, them apostrophe before zip - did n't work

Help
 
D

Dave Peterson

Give it a custom format of: 00000
(select the cells|Format|cells|number tab|custom and type 00000 in that type
box.)

If your zip codes could be 5 or 9 digits, you could use a custom format of:
[>99999]00000-0000;00000

Although I don't know why your previous attempt didn't work.
 

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

Excel 2007 is stupid dealing with zipcodes 2
format cells as zip code not working 3
zip code formatting 1
Zip Code formatting problem 3
How do I zip sort mailing list when I have 5 digit AND 9 digit zip 1
changing zip code to number 3
Format>Cells>Special>Zip Code 5
How do I format zip code (9) to use in Word merg doc 1

Top