View Single Post
  #11   Report Post  
Posted to microsoft.public.word.mailmerge.fields
workliveplay workliveplay is offline
external usenet poster
 
Posts: 5
Default Merge Field Currency Switch Rounding

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.