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.
--
Cheers
macropod
[MVP - Microsoft Word]
"Wisconsin Cheesehead" <Wisconsin Cheesehead[ at ]discussions.microsoft.com> wrote in message
news:743046F0-A9A4-48B6-BEA6-6D09596187DA[ at ]microsoft.com...
[Quoted Text] >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.
|