how do you display a zip code with a leading zero

G

Guest

How do you display a zip code with a leading zero without changing the format
to a text field?
 
G

Guest

Only way i know how to do this is to format cell, look under special and
there is a selection especially for Zip codes.
 
D

Dave Peterson

Maybe you could use a custom format to cover both 5 digits and 9 digit zips:

[>99999]00000-0000;00000
 

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

Formats 2
Exporting ZIP code to CSV drops leading zero 2
leading zeros in zip code 3
How to show a leading 0 in a cell. 2
Using formatted cells in formulas 3
save text field w/ leading zeros in .csv format & not lose zeros? 1
Zip Code question for clarity 1
Zipcodes and Zeros with Office XP Mail Merge 1

Top