Mail Merge from Excel
Why is it that when I merge a number from Excel into a Word doc that any time
the number in Excel includes even one a decimal it is merged into the Word doc with several decimal places? |
Mail Merge from Excel
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. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) Patrick wrote: Why is it that when I merge a number from Excel into a Word doc that any time the number in Excel includes even one a decimal it is merged into the Word doc with several decimal places? -- Dave Peterson |
Mail Merge from Excel
Thanks! Using DDE solved my problem once I knew how to do it!
"Dave Peterson" wrote: 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. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) Patrick wrote: Why is it that when I merge a number from Excel into a Word doc that any time the number in Excel includes even one a decimal it is merged into the Word doc with several decimal places? -- Dave Peterson |
All times are GMT +1. The time now is 09:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com