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

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.
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zip code sort is an Excel problem even when using the special cat. 2
How do I zip sort mailing list when I have 5 digit AND 9 digit zip 1
Turning a 9 digit string into zip+4 3
Changing ZIP code formats in Excel 2003 6
formatting a cell for both ZIP and ZIP+4 4
only 5 digit zip codes 1
how do i keep zip code zeros from disappearing 2
Zip Code Last 4 Digit as Zero 1

Top