ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Maintaining currency formatting in a Mail Merge? (https://www.excelbanter.com/excel-discussion-misc-queries/158435-maintaining-currency-formatting-mail-merge.html)

Martinson44

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?

David Biddulph[_2_]

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?




Dave Peterson

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