I hope this isn't the same person posting from yesterday!! if so send me your
stuff, if not try =text(A1,"00000") then you can copy and paste special
values over your old data.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Booklisa" wrote:

the 1st zero gets dropped from zip codes when address spreadsheet is used for
mail merge.