Negative Number - Brackets instead of negative signs

J

J. Trucking

Hello,

I just had a quick question. I have set up an invoice db but in my
calculations, when the result is negative, the result has a negative
sign in front of the number. I would like to show brackets instead.
Does anyone know how to format things this way.

Thanks in advance,

John
 
R

Rick Brandt

J. Trucking said:
Hello,

I just had a quick question. I have set up an invoice db but in my
calculations, when the result is negative, the result has a negative
sign in front of the number. I would like to show brackets instead.
Does anyone know how to format things this way.

Thanks in advance,

John
Click to expand...

The format property for numbers can be divided into four sections separated
by semi-colons. Each section respectively controls the format for...

Positive values
Negative values
Zero
Null

Example:
#;\[#\];"Zero";"Null"
 
Top