Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Rounding Up Numbers Merged from Excel into Word 2003
I have read all of the strings and advice and figured out the percentage
string. So thanks to everyone on that. However, I still can't seem to get the correct string to round up the numbers from Excel. For example, the number in Excel was rounded up from 17.5 to 18. When I merge it, it comes across as 17.5. I've tried a variety of different things and just can't get it. The last of which was : { { MERGEFIELD "DRUG_RQRD" \ # €œ,0} } Appreciate your feedback and advice. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Rounding Up Numbers Merged from Excel into Word 2003
Hi,
Do you need plain rounding, or rounding up? I ask because 17.5 rounds to 18 (as well as rounding up to 18). For rounding, you couldcode your mergefield as: {MERGEFIELD "DRUG_RQRD" \# 0} or {=ROUND({MERGEFIELD "DRUG_RQRD"},0)} For rounding up, plus a wide range of other calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Rounding Numbers Up Or Down' Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. -- Cheers macropod [MVP - Microsoft Word] "Wisconsin Cheesehead" Wisconsin wrote in message ... I have read all of the strings and advice and figured out the percentage string. So thanks to everyone on that. However, I still can't seem to get the correct string to round up the numbers from Excel. For example, the number in Excel was rounded up from 17.5 to 18. When I merge it, it comes across as 17.5. I've tried a variety of different things and just can't get it. The last of which was : { { MERGEFIELD "DRUG_RQRD" \ # €œ,0} } Appreciate your feedback and advice. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding up on a merged field | Mailmerge | |||
Rounding merged figures | Mailmerge | |||
Losing $ and , in numbers being merged from Excel into Word docume | Mailmerge | |||
How do I format numbers in a Word table, data merged from Excel | Tables | |||
formatting numbers mail merged into Word table from an Excel Works | Tables |