View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merged Format for Negative Currency

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

"pvong" phillip*at*yahoo*dot*com wrote in message
...
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