Forum Discussion
Excel function showing in the cell instead of the result
I am trying to do a simple SUM of a column of numbers, which I have done many times before without a problem, but this time the SUM function is showing up in the cell instead of the result. How do I get the result to show instead?
5 Replies
1) If the number format of the cell is set to Text, change it to General or Number, then press F2 to edit the formula and press Enter without changing anything.
2) Otherwise, activate the Formulas tab of the ribbon. If the Show Formulas button in the Formula Auditing group is highlighted, click it to turn it off.
HansVogelaarI know this is an old thread, but when I toggle off the Show Formulas button, save my document, exit the program, and then reopen it, the Show Formulas is back on. It's only like this for one worksheet, not the entire workbook. Thanks!
Have you opened multiple windows on the workbook?
- #1 worked. Thanks Hans!
- Your second suggestion was spot-on! Thanks so much for the help!!
