Merge Field Currency Switch Rounding

[workliveplay]

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.

 

[Doug Robbins - Word MVP]

You should be able to find out how to do this in fellow MVP, Macropod's Word
Field Maths 'tutorial', at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Graham Mayor]

I think this one needs Macropod's further attention. In the meantime

{ IF{ =MOD({Mergefield Fieldname },1000) } < 500 "{ ={ =INT({ ={ =ROUND ({
Mergefield Fieldname},0) }/1000 }) } * 1000 \# ",$0" }" "{ ={ =INT({ ={
=ROUND ({ Mergefield Fieldname},0) }/1000 }) } * 1000 +1000 \# ",$0" }"}

is not very elegant but it appears to work


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Peter Jamieson]

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

 

[Graham Mayor]

That's certainly better, but not as much fun

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Peter Jamieson]

I get some amusement from the fact that an organisation that's dealing in $
amounts large enough that they want to round them to thousands of dollars
can't work out how to do it. But not a lot

Peter Jamieson

 

[Graham Mayor]

It's probably someone else's money

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Peter Jamieson]

It usually is

Peter Jamieson

It's probably someone else's money

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[macropod]

Hi all,

Perhaps the following would suit the OP better:
{=ROUND({MERGEFIELD myamount},-3) \# "$,0"}

Cheers

 

[Graham Mayor]

I knew you'd have a plan

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[workliveplay]

WOW!

Thanks to all for the prompt responses, with editorial... levity makes the
world a better place!

BTW, Yes it is someone else’s money-surety for land development.

You all have my sincere respect and admiration.

Cheers!

 

[macropod]

World domination!!!

 

[Peter Jamieson]

For a moment I thought you said "Word domination"

Peter Jamieson

World domination!!!

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

I knew you'd have a plan

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[macropod]

There's a difference?

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

For a moment I thought you said "Word domination"

Peter Jamieson

World domination!!!

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

I knew you'd have a plan

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

macropod wrote:
Hi all,

Perhaps the following would suit the OP better:
{=ROUND({MERGEFIELD myamount},-3) \# "$,0"}

Cheers

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
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.

 

[Peter Jamieson]

I'd say

"an 'ell of a difference"

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

Peter Jamieson

There's a difference?

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

For a moment I thought you said "Word domination"

Peter Jamieson

World domination!!!

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

I knew you'd have a plan

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

macropod wrote:
Hi all,

Perhaps the following would suit the OP better:
{=ROUND({MERGEFIELD myamount},-3) \# "$,0"}

Cheers

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
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.