Sum - show negative number?

  • Thread starter Thread starter Steve
  • Start date Start date
I think the current (well, 1990's) terminology is "thinking out of the box".

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

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

Bob
Click to expand...
 
Dave Peterson said:
I think the current (well, 1990's) terminology is "thinking out of the
Click to expand...
box".

I know, and because it is so ubiquitous, I avoid it like the plague.
"Off the wall thinking" is much nicer <bg>.
Click to expand...

I think so too <ebg<
 
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).
Click to expand...

I'm using xl2000, maybe that's why it doesn't work?
 
I'm using XL2000 here and it works.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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.)
 
Dave Peterson said:
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.)
Click to expand...

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