Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a sheet with Column name PtZip and it has Zip code in them... Some of these zip code are old format of 5 char. and I would like to convert them to 9 Char format. Not sure if there is a way by reading the related Address Column can convert 5 Char zip format to 9 char format but at least pad the zip with four zero on the right. so my formating does not show as 00009-2777. -- Jeff B Paarsa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CHAR and CODE | Excel Worksheet Functions | |||
help to adjust my code | Excel Programming | |||
8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
ALT + enter or Char(13) in code | Excel Discussion (Misc queries) | |||
TEXT, CHAR and CODE | Excel Programming |