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

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.

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

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

"marino" wrote in message
...
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.