Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
Mail Merge in Excel | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
Using Excel for a Mail Merge | Excel Worksheet Functions | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |