display problem with brackets

D

david

have got some cells with brackets around numbers.

format is "("General")"

cell A1 contains 4 which displays as (4)

cell A2 = 5 which displays as (5)

but it goes wrong when I calculate...

cell A3 = A1 - A2 which displays as -(1)

but I want it to display as (-1)

how do I get the minus sign inside the brackets?

thanks
 
S

Shane Devenshire

Hi,

If all of your numbers are whole number you could use
(0);(-0)
or
(#);(-#)

And then to display more decimal you simple click the Increase Decimals
button on the toolbar.
 
Top