That's certainly better, but not as much fun
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Peter Jamieson wrote:
For positive amounts,
{ =round({ MERGEFIELD myamount } / 1000,0) \#",$0K" }
?
(All the {} have to be the field code braces you can insert using
ctrl-F9, not the ordinary keyboard characters)
Peter Jamieson
"workliveplay" wrote in
message ...
I am working with MS Office 2003 and trying to round a merge field to
currency rounded to the nearest $1K. I've got the decimal rounding
handled.
Thanks in advance for any input.