how do you display a zip code with a leading zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you display a zip code with a leading zero without changing the format
to a text field?
 
Only way i know how to do this is to format cell, look under special and
there is a selection especially for Zip codes.
 
Maybe you could use a custom format to cover both 5 digits and 9 digit zips:

[>99999]00000-0000;00000
 
You must log in or register to reply here.

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

How to stop Excel from automatically truncating leading zeros 2
How to merge Excel address columns when some zips begin with zeros 4
losing the leading zero when merging zip+4 postal code 1
mail merge in excel/losing leading zero 1
Leading Zero with Function 3
forcing trailing zeros on 5-digit Zip 4
leading zero not displaying 1
Leading Zero 11

Back
Top