Occasionally, I will try to enter a formula to a cell but the cell interprets the typing as text.
E.G. I type "= B1 + 2" into A1.
Rather than the result of the calculation appearing in the A1 cell, "= B1 + 2" shows in the cell.
Why does this happen, please.