View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
above the notch nh above the notch nh is offline
external usenet poster
 
Posts: 1
Default formating zip codes with leading zero to print zero

I live in New England and our zip codes start with zero. When compiling a
mailing list and then merging in Word, the zeros do not print. Is there a way
to get these zeros to print without having to create a formula (which I have
done). Also, I know that if you start with ' and then type your number the
zero will print. I usually get a mailing list that someone has compiled and
then I am stuck adding the ' to get the zeros to print. There must be an
easier way!!!!!