Go to Format - Cells on top menu toolbar
On the Number Tab, in the left window click on Special
In the Locale dropdown, click English (United States)
You can now select Zip Code and any entry in the cell will retain formatting

--

Saruman
----------------------------------------------------------------------------
-------
All Outgoing Mail Checked By Norton Anti-Virus 2003
----------------------------------------------------------------------------
-------

"Kate" wrote in message
...
When we print mailing labels, Excel drops the beginning zero in zip codes
causing us to have to add them manually. We are working with thousands of
labels and this is very time consuming.
Thank you
Kate