In another column do text(A3,"00000") A3 being the cell with the zip and fill
down. then you should be able to copy the column and paste special values
over the old one.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"LStout" wrote:

i have a large mailing list in excell, and everytime i try to mail merge it
into word, it leaves out the first 0 (zero) in all of my zip codes. i have
the column setting set to "zip code" and it still drops the first 0. this is
going to take much too long to type in all of the 0's myself. is there a way
to fix this? thanks!