Forum Discussion
AutoSum not working
The screenshot that Haytham posted seems to indicate that clicking the Data ribbon gives you an option to change the cell format. This is misleading. Instead, you can either (a) select the range of cells and click the Home ribbon to find the indicated format cells dropdown list or (b) select the range of cells then right-click the range and select Format (near the bottom). Finally, apply either General format or the relevant number format.
Deleted , if you'll check screenshort more carefully you see what Home tab is selected.
Yes, I know that. But the starting point of the rightmost arrow seems to indicate that one should start by clicking the Data ribbon and is thus misleading (as is evident from hannaaaase's comment "when I click "data". There is no place to hit numbers").
Not bashing anyone here....just trying to clarify for hannaaaase. SergeiBaklan