How do you display a zip code with a leading zero without changing the format to a text field?
N nicole Jan 24, 2005 #1 How do you display a zip code with a leading zero without changing the format to a text field?
S Slumbering Gorilla Jan 24, 2005 #2 Only way i know how to do this is to format cell, look under special and there is a selection especially for Zip codes.
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 Jan 25, 2005 #3 Maybe you could use a custom format to cover both 5 digits and 9 digit zips: [>99999]00000-0000;00000
Maybe you could use a custom format to cover both 5 digits and 9 digit zips: [>99999]00000-0000;00000
