Displaying negatives with (brackets)
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" wrote:
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
|