label merge leaves beginning zero off zip code

[Guest]

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

 

[Anne Troy]

Hi, Eva. I assume you're talking about mail merge. Please see:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com

 

[Debra Dalgleish]

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

 

[David McRitchie]

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.