View Single Post
  #15   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merge Field Currency Switch Rounding

I'd say

"an 'ell of a difference"

except then I'd have to kill myself...

Peter Jamieson
"macropod" wrote in message
...
There's a difference?

--
macropod
[MVP - Microsoft Word]
-------------------------

"Peter Jamieson" wrote in message
...
For a moment I thought you said "Word domination" :-)

Peter Jamieson

"macropod" wrote in message
...
World domination!!!

--
macropod
[MVP - Microsoft Word]
-------------------------

"Graham Mayor" wrote in message
...
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.