Why is my Excel formula being treated as text?

Despite the = equals sign being at the beginning, is Excel still not reading your formula as a formula? This can happen occasionally.

 

FormulaShowingAsText1

 

The reason is usually that the destination cell (in this case A3) has previously been explicitly formatted as text. Then when the formula is manually typed in, Excel continues to read as text. There is a very simple solution here, simply right-click cell A3, Format Cells, select General as the data type and that will fix it.

 

FormulaShowingAsText2

Leave a Reply

Your email address will not be published. Required fields are marked *