| 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. |
| 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 | |||
Threaded Mode
