formatting negative numbers

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
 
R

Rich/rerat

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top