[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/show...?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

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

[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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





Doug Robbins - Word MVP wrote:
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/show...?Number=365442


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

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

[Graham Mayor]

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.

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

[Graham Mayor]

It's probably someone else's money

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Peter Jamieson wrote:
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" wrote in message
...
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.

[Peter Jamieson]

It usually is :-)

Peter Jamieson

"Graham Mayor" wrote in message
...
It's probably someone else's money

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Peter Jamieson wrote:
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" wrote in message
...
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.

[macropod]

Hi all,

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

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

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

[Graham Mayor]

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.

[workliveplay]

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.

[macropod]

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.

[Peter Jamieson]

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.

[macropod]

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.

[Peter Jamieson]

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.