How do I format zip code (9) to use in Word merg doc

  • Thread starter Thread starter marino
  • Start date Start date
M

marino

Am merging Excel into Word. Zip code cell which I have made "custom" type
[<99999]00000;00000-0000 will not display hyphen in zip code in merged doc.
Have mixed zips -- some 5 digits and some with 5 + 4.
 
You can use a help formula to make it into text

=TEXT(A1,"[<99999]00000;00000-0000")

the copy and paste special as values over the old numbers

or you can post this in a Word newsgroup and they will give you the switch
to use in Word


--


Regards,


Peo Sjoblom
 
Back
Top