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:)

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 :)

Fri, 06 Jul 2007 18:54:02 GMT from DB <Daveb007
:
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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

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" wrote in message
t...
Fri, 06 Jul 2007 18:54:02 GMT from DB <Daveb007
:
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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Sun, 08 Jul 2007 11:27:36 GMT from DB <Daveb007
:

"Stan Brown" wrote in message
t...
Please see the answers in the other newsgroup where you posted this.

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

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

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


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/