J
JRS
I have a contact database where some of the entries
include a 5 digit zip code and some contain a 9 digit zip
code (5+4). Is there a format code I can use to display
both types correctly in my Table? I tried using the code
00000-0000 but then the 5 digit code comes out like 1-
2345. If I use a general number format then the 9 digit
zip codes come out like 123456789. Any ideas? Thanks.
include a 5 digit zip code and some contain a 9 digit zip
code (5+4). Is there a format code I can use to display
both types correctly in my Table? I tried using the code
00000-0000 but then the 5 digit code comes out like 1-
2345. If I use a general number format then the 9 digit
zip codes come out like 123456789. Any ideas? Thanks.