ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Zip codes that start with zero (https://www.excelbanter.com/excel-discussion-misc-queries/23389-zip-codes-start-zero.html)

Gamba Lisa

Zip codes that start with zero
 
I can format the cell as text in Excel and the zeros show up and print fine,
but when I mail merge into WORD, I get a zero ONLY as a zipcode. Frustrating.
I need to print labels by Friday. WHat do I do?

Ragdyer

See if this link helps:

http://office.microsoft.com/enÂ*-ca/...4951033.Â*aspx
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Gamba Lisa" <Gamba wrote in message
...
I can format the cell as text in Excel and the zeros show up and print

fine,
but when I mail merge into WORD, I get a zero ONLY as a zipcode.

Frustrating.
I need to print labels by Friday. WHat do I do?




All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com