WOW!
Thanks to all for the prompt responses, with editorial... levity makes the
world a better place!
BTW, Yes it is someone elses money-surety for land development.
You all have my sincere respect and admiration.
Cheers!
"Graham Mayor" wrote:
I knew you'd have a plan
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
macropod wrote:
Hi all,
Perhaps the following would suit the OP better:
{=ROUND({MERGEFIELD myamount},-3) \# "$,0"}
Cheers
"Peter Jamieson" wrote in message
...
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.