Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel values in Word Mail Merge
Hi all,
I'm trying to use the rounded values in an excel spreadsheet as fields in my mail merge. The merge pulls up the original number with many decimal places. How do I get the merge to show the rounded value? Thanks for your help! Dory |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel values in Word 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. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"ddmmyy") or =text(a2,"mm:ss.0") or =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) dory a wrote: Hi all, I'm trying to use the rounded values in an excel spreadsheet as fields in my mail merge. The merge pulls up the original number with many decimal places. How do I get the merge to show the rounded value? Thanks for your help! Dory -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel values in Word Mail Merge
Thank you Dave and Bruce. It worked great!!!!
"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,"ddmmyy") or =text(a2,"mm:ss.0") or =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) dory a wrote: Hi all, I'm trying to use the rounded values in an excel spreadsheet as fields in my mail merge. The merge pulls up the original number with many decimal places. How do I get the merge to show the rounded value? Thanks for your help! Dory -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge with Excel and Word | Excel Discussion (Misc queries) | |||
Excel 2 Word 2 OE 2 Mail Merge | New Users to Excel | |||
Excel Word Mail Merge | Excel Worksheet Functions | |||
Excel Mail merge two word | Excel Worksheet Functions | |||
Merge mail excel to word | Excel Discussion (Misc queries) |