David,

I am not starting from Zero. I have the zips already in the worksheet, but
can not print them properly. I'm sorry to be such a novice at this, but I'm
not sure how to formulate the entire column to accept the formulas that you
have provided. Is there a way to insert the formalu that you have provided
so that it will simply adjust the entries that I have made without going down
the entire column with the new formula? Trying to get the hang of this so
that I don't have to start over from the beginning. Your help is greatly
appreciated.

"David Biddulph" wrote:

"Omega" wrote in message
...
I have created an Excel database containing addresses (more specifically
zip
codes). I then have attempted to mail merge them into Word and have been
having a heck of a time getting the zip codes to print properly. Each
time I
attempt to print the labels (ie., zip code 08080) the first zero of the
zip
code will not not print for some reason. I have gone back and tried to
change the format of the cell that holds the zip code and still it does
not
work. I have changed the format from Zip to custom (00000) and still no
success. Any suggestions from others who have had the same problem and
found
a remedy would be greatly appreciated.

Apparently the content of your cell is the number 8080, not the text string
08080. Changing the format as you've done doesn't alter the content of the
cell, but if the cell is treated as a number it won't store the leading
zeroes.

You need to turn it into Text (not a number) & concatenate the leading
zeroes.

Try =REPT("0",5-LEN(A1))&A1

If you were starting from square one you could just format the cells as text
*before* you entered the data.
--
David Biddulph