View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeffery B Paarsa Jeffery B Paarsa is offline
external usenet poster
 
Posts: 17
Default Adjust Zip code to 9 Char fmt.

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