| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a HYPHEN to a 9 digit zip code column | Excel Discussion (Misc queries) | |||
| How do I fix loosing 1st digit in zip code in mail merge? | Excel Worksheet Functions | |||
| nine digit zip code won't print in mail merge | Excel Discussion (Misc queries) | |||
| recognizing double digit numbers in code | Excel Discussion (Misc queries) | |||
| 12 digit code sorting | Excel Worksheet Functions | |||
Linear Mode
