Printing zip codes that start with 0

[Guest]

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

 

[Nick Hodge]

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
(e-mail address removed)

 

[Guest]

Thank you. The apostrophe worked!

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
(e-mail address removed)