Simple stupid thing, but very frustrating!
I write a formula and the formula starting with the ‘=’ displays but the result of the formula does not!
View>formula IS NOT checked, other formulas display the results
Both: View> Formula IS NOT checked, flagged!
and
cells are formatted as number
ANY new formula even in blank columns show formula, not results
…
(My umpteenth attempt to fix it):
Not sure how/why, I went to the formula bar, put the cursor at the far left, hit the backspace key a few times, hit ENTER and that cell’s new formula displayed a result
Did that in other cells showing new formula, but that did not display the result
SO
copied and pasted the ‘fixed’ cell on to all the problem cells
They showed results
and now when I enter formula in those cells and anywhere in the sheet the formulas are displayed.
Makes now consistent sense.
Gremlins?