Hi Brian

right mouse click on your formula cell, choose format / cells, and have a
look under the number category on the number tab - choose the format you
want and click ok
- if the format you want isn't there you can create your own under custom -
have a look at help or post back for additional details on how to do this.

Cheers
JulieD

"brian" wrote in message
...
Would somebody please tell me what formula to add to an
existing formula to show and print a resultant minus
value in red when the basic formula shows results in
black The basic formula is =SUM where the cells to be
added contain both + & - values
Thanks
Brian UK