Even simple formula will not calculate?

%3CLINGO-SUB%20id%3D%22lingo-sub-2252605%22%20slang%3D%22en-US%22%3EEven%20simple%20formula%20will%20not%20calculate%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2252605%22%20slang%3D%22en-US%22%3E%3CP%3EI%20typed%20in%20a%20complex%20formula%20and%20it%20did%20not%20calculate.%26nbsp%3B%20So%20it%20typed%20in%20a%20simple%20%3Dsum(B2%2BB3)%2C%20but%20I%20just%20see%20the%20formula%20not%20the%20result.%26nbsp%3B%20I%20have%20never%20had%20this%20happen%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2252605%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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.