If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Zip Code Last 4 Digit as Zero
I have a Zip Code Table with only the first 5 digits and do not have the last
4 digit. How can I make them in 9 digit zip code with the last 4 digit as 0000?. manually I've been doing this (01234 then add the last digit as -0000) which come to this 01234-0000. |
#2
|
|||
|
|||
Zip Code Last 4 Digit as Zero
With a five digit ZIP code in A1, in another cell:
=A1 & "-0000" -- Gary''s Student - gsnu201003 "cheppy" wrote: I have a Zip Code Table with only the first 5 digits and do not have the last 4 digit. How can I make them in 9 digit zip code with the last 4 digit as 0000?. manually I've been doing this (01234 then add the last digit as -0000) which come to this 01234-0000. |
Thread Tools | |
Display Modes | |
|
|