| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maintaining currency formatting in a Mail Merge?
How do I maintain (or permanently convert to text) formatted cells from Excel
when using it with a Mail Merge in Word? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maintaining currency formatting in a Mail Merge?
Look at the TEXT function. You'll find details in Excel help.
-- David Biddulph "Martinson44" wrote in message ... How do I maintain (or permanently convert to text) formatted cells from Excel when using it with a Mail Merge in Word? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maintaining currency formatting in a Mail Merge?
You can also format the values when you do the mail merge.
Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. Martinson44 wrote: How do I maintain (or permanently convert to text) formatted cells from Excel when using it with a Mail Merge in Word? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I lose my number formatting in the mail merge? | Excel Discussion (Misc queries) | |||
| Cell formatting in Mail Merge | Excel Discussion (Misc queries) | |||
| when I mail merge my data (currency) format is lost? Help | Excel Discussion (Misc queries) | |||
| How do you keep Excel currency formatting during a mail merge? | Excel Discussion (Misc queries) | |||
| in mail merge how do i convert currency from excel to word | Excel Discussion (Misc queries) | |||
Hybrid Mode
