Feb 28 2023 07:31 AM
If I select the column of figures starting at the bottom-most value, the SUM in the status bar is correctly negative. If I start with the topmost value, the SUM is positive.
Feb 28 2023 07:50 AM
Feb 28 2023 08:16 AM
Feb 28 2023 08:22 AM
Feb 28 2023 08:27 AM - edited Feb 28 2023 08:33 AM
Feb 28 2023 08:42 AM
Feb 28 2023 09:01 AM
SolutionFeb 28 2023 10:54 AM
Feb 28 2023 11:57 AM - edited Mar 01 2023 09:01 AM
@Hecatonchire wrote: ``It'ss the format of the active cell that is used for display in the status bar``
Excellent find! Easy to duplicate -- even in Excel 2010.
Fill A1:A10 with -1 formatted as General. But format A10 as Custom 0;0 (missing minus sign on purpose).
Select A1 to A10 (i.e. A1 is the active cell), and the status bar sum is -10, as expected.
But select A10 to A1 (i.e. A10 is the active cell), and the status bar sum appears to be 10 (positive).
-----
@L1ANE wrote: ``I can't imagine [...] why the format of that cell should affect the status bar``
I agree that it can be a surprise. But having had it explained, it makes good sense in general, IMHO.
Certainly, we would like the status bar sum to reflect the format of the data. If all of the data is currency, the sum should appear to be the same currency. If all of the data is time, the sum should appear to be time. If all of the data is percentage, the sum should appear to be percentage. Etc.
But what format should the status bar choose if not all of the data is the same format?
I believe there are two reasonable choices: (1) a default format (probably General); or (2) the active cell.
I'm happy with the latter, especially if the data is time or a custom format like
[<1000]0;[<1000000]0,\K;0,,\M
Apparently MSFT chose the latter. (My opinion does not matter.)
Feb 28 2023 12:18 PM
Mar 01 2023 12:09 AM
Feb 28 2023 09:01 AM
Solution