Many Thanks for the info..

Im sorted out now..

DB :))






"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
Why not custom-format it with a leading minus sign, but then actually
subtract it? Of course, if others use the workbook, they will be mightily
confused. :-)

[Red]-#,##0.00_)
__________________________________________________ _______________________


"DB" wrote in message
. uk...
I'm trying to work something out and I am trying to find out if something
is
possible...

Basically I do the losses and gains at work for various stocks - I
manually
work out the losses and gains, recording them on a weekly basis.

The format is as follows.......

A B C D E
Date Loss Gain Net
Result this week Result to Date
1 1/7/07 -50.00 -26.00 - -26.00
2 8/7/07 -100.00 170.00 100.00
74.00
3
4
5
6
7
8
9

Is there a way that can treat the whole B column as Negative, rather than
having to input using a minus (-) sign .

I know it is a tiny problem - but is it possible ?

Many Thanks

DB:)