zip codes don't merge

  • Thread starter Thread starter bb
  • Start date Start date
B

bb

I am trying to mail merge w/ Word 2000 the names and addresses in my
worksheet. When I get to the part to choose the format for the mailing
labels, I choose F1, F2, etc. to F6 (which is the zip code column). A few
do get there, but the vast majority stop at the state, leaving off the
entire zip code.
I have gone to menu/format and selected text in the number tab. I have gone
to format/cells and chosen special/zip code in the number tab. I've read
Excel for Dummies. Please help me. TIA
bb
 
Simply changing the format between text and number or number and text
will not change the format of the content, you also have to provide some
means of reentry. You change the 5 digit codes to text with the macro
FixUSzip5 in
http://www.mvps.org/dmcritchie/excel/join.htm#fixuszip5
the nine digit zipcodes entered in a General format will alread by text,
so will not be affected.
 
Back
Top