formatting negative numbers

  • Thread starter Thread starter JCFFinance
  • Start date Start date
J

JCFFinance

How do I change the format of -1,250.00 to appear as (1,250.00) on my word
document. It is a merge document....the number is in a field within the table
 
JCFFinance,

add the following Switch to the mergefield

\# ",0.00;(,0.00)"

So it will look like this

{mergefield "amount" \# ",0.00;(,0.00)"}

More great info on Formatting with Word Switches found on Graham Mayor web
site:
http://www.gmayor.com/formatting_word_fields.htm

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat (RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


How do I change the format of -1,250.00 to appear as (1,250.00) on my word
document. It is a merge document....the number is in a field within the
table
 
Back
Top