![]() |
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? |
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? |
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 |
All times are GMT +1. The time now is 12:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com