Even simple formula will not calculate?

Copper Contributor

I typed in a complex formula and it did not calculate.  So it typed in a simple =sum(B2+B3), but I just see the formula not the result.  I have never had this happen?

2 Replies

@Bertramus I suspect that you accidentally switched on "Show Formulas" on the formula ribbon.

Screenshot 2021-04-04 at 04.43.42.png

Thanks @Riny_van_Eekelen It turns out the numeric had been converted to text.