Function returns itself vice results

B

BethD

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

Duke Carey

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

T. Valko

Try this:

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

BethD

I tried this and it did not work. I am stymied. It is formatted as General.
I took off any bold, centering, turned it vanilla as I could. The F2 and
enter still leaves me with =LEN(H2)
 
T

T. Valko

Check this setting....

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Justification function versus wide spaces 0
Transfer data between two tables 3
Determine if previous "character" is a section break 3
Prompt For Replace in Selection And More... 0
Excel - Wich Function should I use? 1
Problem with SET & REF function 0
XIRR vs. IRR Function 11
How to display the merge function "url" of a picture? 0

Top