using zip codes in excel

J

Joyce Copleman

When I type in a zip code like 08648, the 0 disappears and it
registers as 8648 in the list. How can I get the 0 to stay in the zip
code.
 
J

J.E. McGimpsey

When I type in a zip code like 08648, the 0 disappears and it
registers as 8648 in the list. How can I get the 0 to stay in the zip
code.
Click to expand...

If you want to enter them as numbers, try formatting them with
Format/Cells/Number/Special/Zip code (or just
Format/Cells/Number/Custom 00000)

Since zip codes aren't used in math operations, you can also enter
them as Text, either by preformatting the cells as Text and enterign
the zipcodes with the leading zero, or prefixing each entry with an
apostrophe (')
 
Top