Try this:

Select the cell in question
Goto the menu FormatCellsNumber tabGeneralOK
Hit funtion key F2
Hit ENTER

--
Biff
Microsoft Excel MVP


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