Excel formulas not working, appearing as text


Once in a while everyone is bound to come across this problem. You type a formula in a cell, then you press ENTER. Bam! nothing happens. The formula shows up in the cell instead of the result, like this:

Excel Formulas are not working?!? What to do when all you see is the formula, not result

 

Possible solution 1:

You may have accidentally pressed CTRL+` (back quote symbol, the key below escape key in your keyboard) or activated the “Show Formulas” mode in Excel.

When you do it, excel shows the formulas instead of their results.

To fix this error and get back the values (or results) just press CTRL+` again.

Possible solution 2:

You may have set the cell formatting to “Text” and then typed the formula in it.

When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it.

To fix this error, just select the cell, set its formatting to “General”. Now edit the formula and press enter. (Alternatively you can press F2 and then Enter after setting format to General).

 

Possible solution 3:

You may have accidentally typed a single quote ‘ before the = sign in the formula.

When you type single quote ‘ in a cell excel treats the cell contents as text and does not evaluate any formulas within.

To fix this error, just remove the single quote.

 

Source: http://chandoo.org/wp/2010/04/12/excel-formulas-are-not-working/