Govind <adgraj1@indiatimes.com> 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?

>Are you talking about the sum in the status bar. It does display the sum
>as negative number as well.

Yep, the status bar. As an example, entered -600 in one cell and +500
in the next. The status bar says Sum=100.

Just played around with this a bit - apparently Excel does not
recognize numbers in red as negative, unless they're also in
parentheses - in spite of the fact that cell formatting provides the
option of unadorned red numbers to indicate negatives. This must be
some sorta bug?