Negative numbers with parenthesis

  • Thread starter Thread starter Spinbud
  • Start date Start date
S

Spinbud

How do I make negative numbers in a report have parenthesis around them? With
currency it is very easy but I cannot figure out how to do it with
non-currency numbers (there is no format that is obvious)

Many thanks.
 
How do I make negative numbers in a report have parenthesis around them? With
currency it is very easy but I cannot figure out how to do it with
non-currency numbers (there is no format that is obvious)

Many thanks.
Click to expand...

Set the Format property of the control on the report to:
#;(#);0;

Look up Format Property + Number and Currency datatypes for
information on why this works.
 
Thanks, this worked. Quick question, how do I get the comma when more than a
thousand, for example, (3,456) instead of (3456).

Many thanks.
 
Thanks, this worked. Quick question, how do I get the comma when more than a
thousand, for example, (3,456) instead of (3456).

Many thanks.
Click to expand...

You're not limited to just #.
You could use
#,###;(#,###);0
or ....
The below will display the comma separated thousands and also always
show 2 decimals.

#,##0.00;(#,##0.00);0.00;

displays as
1,234.00 or (1234.00)
1,234.10 or (1,234.10)
0.25 or (0.25)
0.05 or (0.05)
0.00
etc......
 
Thank you very, very much. You have answered my question very well. I
appreciate your time.
 
Back
Top