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



Steve wrote:
>
> Dave Peterson <petersod@verizonXSPAM.net> wrote:
> >> If I highlight several numbers in a column, Excel will indicate the
> >> sum. But it always shows that sum as a positive number, even if it's
> >> actually negative. Is there any way to change this behavior?
>
> >If I selected my cells, then ctrl-clicked on an empty cell (general format),
> >then the statusbar showed the sum in general format.
> >Maybe you could try it as a workaround.
>
> Sounds good, but I just tried it, and there was no change in the
> status bar sum. Must be doing something wrong...

--

Dave Peterson