Leading 0 in Mail Merge document
 

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.
--
Karina

Leading 0 in Mail Merge document
 

Did u try to format it as text, too?

"Karina" wrote:

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.
--
Karina

Leading 0 in Mail Merge document
 

Yes
--
Karina


"Alojz" wrote:

Did u try to format it as text, too?

"Karina" wrote:

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.
--
Karina

Leading 0 in Mail Merge document
 

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

On Tue, 3 Feb 2009 16:41:01 -0800, Karina
wrote:

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.

Leading 0 in Mail Merge document
 

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/as...164951033.aspx
http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm
--
David Biddulph

Karina wrote:
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.

Leading 0 in Mail Merge document
 

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


"Gord Dibben" wrote:

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

On Tue, 3 Feb 2009 16:41:01 -0800, Karina
wrote:

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.