Thread: Zip Code Formatting
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie David McRitchie is offline
external usenet poster
  
Posts: 903
Default Zip Code Formatting
Hi Jerry,
Zip codes should really be text instead of numbers, to convert them
in place to text with a macro retaining all digits that you have, see
Fix up for 5 digit US zip codes (#fixUSzip5)
http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5
---
HTH,
David McRitchie,
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


Reply With QuoteReply With Quote