Thread: zip code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jillteresa jillteresa is offline
external usenet poster
 
Posts: 1
Default zip code


Hi there,
I have a file with zip codes. In this file, all zip codes that
normally begin with "0" are missing the zero. For instance, 06882 is
showing 6882. I need to add the zeros in somehow, quicky. Is there a
way to convert this data?
Jill



--
jillteresa
------------------------------------------------------------------------
jillteresa's Profile: http://www.excelforum.com/member.php...fo&userid=9498
View this thread: http://www.excelforum.com/showthread...hreadid=570026