Cell Formula

[cstimart]

I've encountered instances where I have typed in a formula in a cell and when I "return", the formula is displayed, rather than the value.

Any Ideas?

 

[c_m_s_jr]

Check the format of the cell. If it is formatted as text then you will get the value in the cell and not the results of the formula.

If it is formatted as text, you will need to change it to "general" then make sure you either double click on that cell or select it, hit F2 then enter. That should flip it back.

 

[T. Valko]

I've encountered instances where I have typed in a formula in a cell and when I "return", the formula is displayed, rather than the value.

Any Ideas?

One possibility is that the cell is formatted as text.

Change the cell format to GENERAL.
With the cell still selected, hit function key F2 then hit ENTER.