Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
"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? |
#6
|
|||
|
|||
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 negative sign in when using the status bar. If you make your format such that it has a negative sign as well as being red then Excel will provide a negative sign in the status bar. Your problem stems from the fact that the 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? |
#7
|
|||
|
|||
"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 negative sign in when using the status bar. If you make your format such that it has a negative sign as well as being red then Excel will provide a negative sign in the status bar. Your problem stems from the fact that 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. |
#8
|
|||
|
|||
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 negative sign in when using the status bar. If you make your format such that it has a negative sign as well as being red then Excel will provide a negative sign in the status bar. Your problem stems from the fact that 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... |
#9
|
|||
|
|||
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. 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? -- Dave Peterson |
#10
|
|||
|
|||
Dave Peterson 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... |
#11
|
|||
|
|||
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 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 |
#12
|
|||
|
|||
Dave Peterson 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... 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? |
#13
|
|||
|
|||
I'm using XL2000 here and it works.
-- HTH RP (remove nothere from the email address if mailing direct) "Steve" wrote in message ... Dave Peterson 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... 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? |
#14
|
|||
|
|||
I really don't know where you come up with them from <g
Bob "Dave Peterson" wrote in message ... 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. 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? -- Dave Peterson |
#15
|
|||
|
|||
Thanks, er, I think. <vbg
Bob Phillips wrote: I really don't know where you come up with them from <g Bob "Dave Peterson" wrote in message ... 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. 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? -- Dave Peterson -- Dave Peterson |
#16
|
|||
|
|||
It's a compliment. Off the wall thinking <bg
Bob "Dave Peterson" wrote in message ... Thanks, er, I think. <vbg Bob Phillips wrote: I really don't know where you come up with them from <g Bob "Dave Peterson" wrote in message ... 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. 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? -- Dave Peterson -- Dave Peterson |
#17
|
|||
|
|||
I think the current (well, 1990's) terminology is "thinking out of the box".
"Off the wall thinking" is much nicer <bg. Bob Phillips wrote: It's a compliment. Off the wall thinking <bg Bob "Dave Peterson" wrote in message ... Thanks, er, I think. <vbg Bob Phillips wrote: I really don't know where you come up with them from <g Bob "Dave Peterson" wrote in message ... 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. 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? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show month number as month name in Excel? | Excel Discussion (Misc queries) | |||
How do I change the display of a negative number to just read 0? | Excel Discussion (Misc queries) | |||
Creating a function that makes a negative number a zero | Excel Discussion (Misc queries) | |||
### when the number is NOT negative? | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel |