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?