Why is Excel displaying the formula as text
 

It is probably because the cell is formatted as text. To get back the
formula, first format the text as general and then click on the cell then in
the formula bar and press enter.



"Richard" wrote:

This isnt the situation where the formula versus value is being shown. This
is a situation where it thinks the formula is a text value.