View Single Post
  #4   Report Post  
David McRitchie
 
Posts: n/a
Default

You can avoid the problem by making the zipcodes text and not numbers
then you could use zip codes from other countries as well.
http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5

If you are going to be specifically printing labels with Mail Merge
you might also see my mailmerg.htm page, but I think
you've already got that part.

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Eva Anne" wrote in message ...
I have set up the zip code column as a zip code in my excel sheet
but when I attempt to label merge it drops the zero. The zero value
check box is checked under Tools/Options. Help