| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code Date Format Depending on Computer format | Excel Discussion (Misc queries) | |||
| How to merge cells in Word document by VBA code?? | Excel Discussion (Misc queries) | |||
| VLOOKUP 1 stop Answer: 3 steps: count dup's, compare dif's, merg | Excel Discussion (Misc queries) | |||
| How do I get macro to unmerge cells that have been previously merg | New Users to Excel | |||
| Merg Worksheets | Excel Worksheet Functions | |||
Linear Mode
