Rounding Up Numbers Merged from Excel into Word 2003

[Wisconsin Cheesehead]

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.

 

[macropod]

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/showthreaded.pl?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.