Merged Format for Negative Currency

[pvong]

I took this straigt from MSFT website.
{MERGEFIELD "MktVal" \# $####,0.00}



If I get a negative value, I get $- 123.45.



How do I change this so I get either -$123.45 or ($123.45)



Thanks!

Phil

 

[Doug Robbins - Word MVP]

Use { MERGEFIELD "MktVal" \# "$,0.00;($,0.00)" }

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


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