ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Auto Sum doesnt work (https://www.excelbanter.com/excel-discussion-misc-queries/244453-auto-sum-doesnt-work.html)

NAS

Auto Sum doesnt work
 
When I try to an autosum in a cell, it doesnt show the calculation, it still
shows the expression. Anyone know why?

Bob Umlas[_3_]

Auto Sum doesnt work
 
Cell is either formatted as text or you're looking at the formula layer.
1st case: reformat as General (ctrl/shift/tilde (~)) and reenter;
2nd case: ctrl/tilde(~) to show value layer.

"NAS" wrote in message
...
When I try to an autosum in a cell, it doesnt show the calculation, it
still
shows the expression. Anyone know why?





All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com