View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default 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