Printing zip codes that start with 0
 

I formatted the cell for zip codes and in Excel 2003, the 0 shows up but when
I try to mail merge into a Publisher document, it won't print the 0 in zip
codes that start with 0. Please help

That's because Excel is only showing the leading zero because of the format.
Try preceding the data with a single apostrophe or pre-format the cells as
text

If this still doesn't work, try using the TEXT function to correct the data

=TEXT(A2,"000000")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ET13" wrote in message
...
I formatted the cell for zip codes and in Excel 2003, the 0 shows up but
when
I try to mail merge into a Publisher document, it won't print the 0 in zip
codes that start with 0. Please help

Thank you. The apostrophe worked!

"Nick Hodge" wrote:

That's because Excel is only showing the leading zero because of the format.
Try preceding the data with a single apostrophe or pre-format the cells as
text

If this still doesn't work, try using the TEXT function to correct the data

=TEXT(A2,"000000")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ET13" wrote in message
...
I formatted the cell for zip codes and in Excel 2003, the 0 shows up but
when
I try to mail merge into a Publisher document, it won't print the 0 in zip
codes that start with 0. Please help