Leading 0 in Mail Merge document

[Karina]

When i am trying to do a mail merge and 1 of the columns has all of the zip
codes, the labels, once the mail merge is complete, only shows 4 digits for
those zip codes that start with a 0. How do i get the word document to pick
up the leading 0 from the excel document. I tried custom formatting it for 5
digits as well as formatting it as a zip code. I am using Microsoft Excel
2003.

 

[Alojz]

Did u try to format it as text, too?

 

[Karina]

Yes
--
Karina

Did u try to format it as text, too?

 

[Gord Dibben]

Two solutions.

1. In Excel use a helper column =TEXT(cellref,"00000")

2. In Word you can format the field for leading 0.


Gord Dibben MS Excel MVP

 

[David Biddulph]

Either in Excel use =TEXT(A1,"00000") or use field formatting in Word
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx
http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

 

[Karina]

Wow, thank you so much. It worked
--
Karina

Two solutions.

1. In Excel use a helper column =TEXT(cellref,"00000")

2. In Word you can format the field for leading 0.


Gord Dibben MS Excel MVP