Negative Column - Is this possible?

[DB]

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

 

[DB]

Well, that didnt work out as planned.....I posted it and reviewed
it.............the E column has wrapped around

It should be A to E

Date, 1/7/07 then the loss figure.....then the gain figure......then the net
result for the week.....then the net result for the year so far..


Cheers

DB

 

[Stan Brown]

Fri, 06 Jul 2007 18:54:02 GMT from DB <Daveb007
(e-mail address removed)>:

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.

Please see the answers in the other newsgroup where you posted this.

In future, please don't post the same question twice.

 

[DB]

In Future Stan..... please be a bit more polite to newcomers........

DB

P.S.... Dont bother telling me off about top posting either.......

 

[Stan Brown]

Sun, 08 Jul 2007 11:27:36 GMT from DB <Daveb007
(e-mail address removed)>:

In Future Stan..... please be a bit more polite to newcomers........

Help me out here. What words would you find acceptable?