"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