Function returns itself vice results

[BethD]

I typed in function =LEN(H2) and when I hit return, the function appears in
the cell but the result does not appear.

 

[Duke Carey]

the cell is apparently formatted as text. Change it to General and then
press F2 followed by enter

 

[T. Valko]

Try this:

Select the cell in question
Goto the menu Format>Cells>Number tab>General>OK
Hit funtion key F2
Hit ENTER

 

[T. Valko]

Check this setting....

Tools>Options>View tab>in Window options uncheck Formulas>OK