[aedcone]

I have created a data source in Excel 2007 with addresses. When I mail merge
to create address labels in Word 2007, my ZipCodes are NOT appearing
correctly. The zip codes all begin with "O" and when I merge it's dropping
the "O." In Excel I have formated the column as ZipCode (not the the 9 digit
zipcode). In Excel I see the "0," BUT when I look up in the forumla bar the
"0" doesn't appear.

Any suggestions how to solve this would be greatly appreciated.

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"aedcone" wrote in message
...
I have created a data source in Excel 2007 with addresses. When I mail
merge
to create address labels in Word 2007, my ZipCodes are NOT appearing
correctly. The zip codes all begin with "O" and when I merge it's
dropping
the "O." In Excel I have formated the column as ZipCode (not the the 9
digit
zipcode). In Excel I see the "0," BUT when I look up in the forumla bar
the
"0" doesn't appear.

Any suggestions how to solve this would be greatly appreciated.

[BFairall2008]

Make sure that the format in excel is in number format.

"aedcone" wrote:

I have created a data source in Excel 2007 with addresses. When I mail merge
to create address labels in Word 2007, my ZipCodes are NOT appearing
correctly. The zip codes all begin with "O" and when I merge it's dropping
the "O." In Excel I have formated the column as ZipCode (not the the 9 digit
zipcode). In Excel I see the "0," BUT when I look up in the forumla bar the
"0" doesn't appear.

Any suggestions how to solve this would be greatly appreciated.