If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Sum - show negative number?
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Sum - show negative number?

#1
July 21st 05, 11:09 PM
 Steve external usenet poster Posts: n/a
Sum - show negative number?

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?
#2
July 22nd 05, 12:16 AM
 Govind external usenet poster Posts: n/a

Hi,

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

Govind

Steve 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?

#3
July 22nd 05, 12:29 AM
 Steve external usenet poster Posts: n/a

Govind > 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?

#4
July 22nd 05, 12:40 AM
 Bob Phillips external usenet poster Posts: n/a

Excel does not per se recognise any format as negative numbers, it
recognises negative numbers by the fact that they are less than 0, either
entered as less than zero, or as a result of a calculation. Red, and/or
parentheses are just a way of showing a number in the visual presentation of
that cell. You could just as easily format positive numbers with parentheses
as you could negative numbers.

--

HTH

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

"Steve" > wrote in message
...
> Govind > 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?
>

#5
July 22nd 05, 01:17 AM
 Ken Wright external usenet poster Posts: n/a

Not really, if you have your values showing as red with no negative sign
that is a conscious choice you have made when selecting the formats for
those cells and Excel respects it. Why would you then expect Excel to put a
that it has a negative sign as well as being red then Excel will provide a
status bar does not have the facility to show a red font.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"Steve" > wrote in message
...
> Govind > 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?
>

#6
July 22nd 05, 01:42 AM
 Steve external usenet poster Posts: n/a

"Bob Phillips" > 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?

>Excel does not per se recognise any format as negative numbers, it
>recognises negative numbers by the fact that they are less than 0, either
>entered as less than zero, or as a result of a calculation. Red, and/or
>parentheses are just a way of showing a number in the visual presentation of
>that cell.

That makes perfect sense - so it must mean that Excel is not capable
of showing the color red in the status line? And therefore, without
formatting the cell to include the minus sign or parentheses, there's
no way to tell whether the Sum is positive or negative?

#7
July 22nd 05, 01:45 AM
 Steve external usenet poster Posts: n/a

"Ken Wright" > wrote:
>Not really, if you have your values showing as red with no negative sign
>that is a conscious choice you have made when selecting the formats for
>those cells and Excel respects it. Why would you then expect Excel to put a
>that it has a negative sign as well as being red then Excel will provide a
>status bar does not have the facility to show a red font.

Ok, thanks, that explains it (posted my last message before I saw this
explanation). Of course, it would be nice if there was some kinda
warning or explanation when choosing that cell format option. And
even better if the status bar was capable of showing the color red.

#8
July 22nd 05, 01:51 AM
 Steve external usenet poster Posts: n/a

Steve > wrote:
>"Ken Wright" > wrote:
>>Not really, if you have your values showing as red with no negative sign
>>that is a conscious choice you have made when selecting the formats for
>>those cells and Excel respects it. Why would you then expect Excel to put a
>>that it has a negative sign as well as being red then Excel will provide a
>>status bar does not have the facility to show a red font.

>
>Ok, thanks, that explains it (posted my last message before I saw this
>explanation). Of course, it would be nice if there was some kinda
>warning or explanation when choosing that cell format option. And
>even better if the status bar was capable of showing the color red.

One reason I like to use plain red is that it makes the numbers easier
to read, without the parentheses. A second-best option would be red
with a negative sign. But that doesn't appear to be possible...

#9
July 22nd 05, 02:19 AM
 RagDyer external usenet poster Posts: n/a

You can create a custom format to show almost *anything* you want.

Custom format for red and minus sign:

#,##0.00;[Red]-#,##0.00

And of course, you could add the parenthesis also:

#,##0.00_);[Red](-#,##0.00)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Steve" > wrote in message
...
> Steve > wrote:
> >"Ken Wright" > wrote:
> >>Not really, if you have your values showing as red with no negative sign
> >>that is a conscious choice you have made when selecting the formats for
> >>those cells and Excel respects it. Why would you then expect Excel to

put a

such
> >>that it has a negative sign as well as being red then Excel will provide

a

the
> >>status bar does not have the facility to show a red font.

> >
> >Ok, thanks, that explains it (posted my last message before I saw this
> >explanation). Of course, it would be nice if there was some kinda
> >warning or explanation when choosing that cell format option. And
> >even better if the status bar was capable of showing the color red.

>
> One reason I like to use plain red is that it makes the numbers easier
> to read, without the parentheses. A second-best option would be red
> with a negative sign. But that doesn't appear to be possible...
>

#10
July 22nd 05, 05:39 AM
 Steve external usenet poster Posts: n/a

"RagDyer" > wrote:
>> >Ok, thanks, that explains it (posted my last message before I saw this
>> >explanation). Of course, it would be nice if there was some kinda
>> >warning or explanation when choosing that cell format option. And
>> >even better if the status bar was capable of showing the color red.

>>
>> One reason I like to use plain red is that it makes the numbers easier
>> to read, without the parentheses. A second-best option would be red
>> with a negative sign. But that doesn't appear to be possible...

>You can create a custom format to show almost *anything* you want.
>Custom format for red and minus sign:
>#,##0.00;[Red]-#,##0.00
>And of course, you could add the parenthesis also:
>#,##0.00_);[Red](-#,##0.00)

Thanks, I'll give those a try. What I'd really like to be able to
customize is the status bar, to show the color red or use the minus
sign even though I haven't used it in the cells...

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post show month number as month name in Excel? Phil Hart Excel Discussion (Misc queries) 3 June 20th 05 06:12 PM How do I change the display of a negative number to just read 0? [email protected] Excel Discussion (Misc queries) 2 April 18th 05 11:03 AM Creating a function that makes a negative number a zero Tina Excel Discussion (Misc queries) 2 April 1st 05 05:28 PM ### when the number is NOT negative? molly Excel Worksheet Functions 5 March 30th 05 01:05 AM UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM

All times are GMT +1. The time now is 09:31 AM.