View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default mail merge and zip codes

Which sid are you having the problem on? Does it look right in Excel but
wrong in word? Or can you not get it to look right anywhere? And what i just
thought of, what format is the zip code in? US?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"LStout" wrote:

i have a mailing list in excell and i am trying to mailmerge it in word. but
if there is a 0 (zero) as the first digit in the zip code, it gets dropped in
the mail merge. i have already tried putting text(A3,"00000") A3 being the
cell in another column and then filling down, but it's still not working. any
suggestions?