Displaying negatives with (brackets)

  • Thread starter Thread starter gew
  • Start date Start date
G

gew

Hello all,
For some reason i cant get excel 2007 to display negative numbers as
brackets! i have looked at all the different formats for the cell, but they
all show up negative numbers as a - sign.
when they are in brackets it is much easier to cee which numbers are
negative, is there a patch or something i can do to change this?
thanks
 
Gew
I don't think there is an easy solution to your bracket problem other than
maybe writing a VBA routine. However, hove you thought about using Excel's
way of identifying negative number by automatically changing the font colour
of negative numbers red ?!
 
Gew
Had another thought:
Click on "Format", then click on "Cells", then click on "custom"
Now near the bottom of the list you should see:
#,##0;[Red]#,##0
Now click on this one and it should appear in the type box. You need to do
the following changes to it:
#,##0;[Black](#,##0)
and then click OK
Hope this helps



You will now be able to display a negative number in brackets
 
did you look at custom in the cell formats?
on the home tab, click the number format dropdown. select more number
formats and then custom.

if you don't see one you like, make one.

($123.00)
 
Back
Top