[DP]

Thanks for taking time to reply. We did get this far with excel but after
the mail merge into Word labels, the zero dropped again.

"cappy" wrote:

What you can do is select the cells with the zip codes in your database,
right click the mouse for a menu, select format cell, on the top tab select
number, then select special, then select zip code. This will format all 5
characters, even if they have leading zeros...

"dp" wrote:

Using 2007 Excel and 2007 Word
A co-worker has a name/addr file in Excel and formatted the zip column as
category, special 00000. Zip shows fine.

However when uses word mail merge to produce mailing labels, the leading
zeros are dropped.

What need to be done?

TIA