Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
pvong pvong is offline
external usenet poster
 
Posts: 2
Default Merged Format for Negative Currency

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


  #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




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make currency print correctly in merged document? Confedlady Mailmerge 2 May 3rd 06 03:55 PM
How to format negative numbers in Word tables Warrain Tables 9 March 17th 06 04:41 PM
currency fields merged incorrectly in word maryfarb Mailmerge 1 July 22nd 05 06:48 PM
Currency fields in Access lose th currency format whn merged why PMasters Mailmerge 1 June 1st 05 08:13 PM
How do I reformat currency merged from Access query Richard Berrill Microsoft Word Help 2 January 11th 05 11:26 AM


All times are GMT +1. The time now is 04:06 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"