Sum - show negative number?

[Dave Peterson]

I think the current (well, 1990's) terminology is "thinking out of the box".

"Off the wall thinking" is much nicer <bg>.

It's a compliment. Off the wall thinking <bg>

Bob

 

[Bob Phillips]

I think the current (well, 1990's) terminology is "thinking out of the

box".

I know, and because it is so ubiquitous, I avoid it like the plague.

"Off the wall thinking" is much nicer <bg>.

I think so too <ebg<

 

[Steve]

I just tried it again (I use xl2003) and when I hit that ctrl-click on the empty
cell, the number on the statusbar changed from 2 to -2 (it was negative all the
time).

I'm using xl2000, maybe that's why it doesn't work?

 

[Bob Phillips]

I'm using XL2000 here and it works.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Steve]

I'm using XL2000 here and it works.

hmmm, wonder what the heck I'm doing wrong...

 

[Dave Peterson]

I formatted my cells by:

selecting the range
format|cells|number tab
Number (0 decimals) and red negative numbers.

And that unused cell was formatted as General.

(and I ctrl-clicked on that unused cell after selecting the other range.)

Did you do anything that varied from that?

If yes, explain what you did to see if anyone can duplicate it. (but try it one
more time using this technique.)

 

[Steve]

I formatted my cells by:
selecting the range
format|cells|number tab
Number (0 decimals) and red negative numbers.
And that unused cell was formatted as General.
(and I ctrl-clicked on that unused cell after selecting the other range.)

Thanks Dave, this works. I think the problem was that the ctrl-click
cell was not formatted as General.

 

[Dave Peterson]

woohoo!!!

Glad you got it working.

Thanks Dave, this works. I think the problem was that the ctrl-click
cell was not formatted as General.