Function returns itself vice results

  • Thread starter Thread starter BethD
  • Start date Start date
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.
 
the cell is apparently formatted as text. Change it to General and then
press F2 followed by enter
 
Try this:

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

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

Lookup returning wrong results 0
This function returns incorrect value sporadically 1
Formatting text within functions 3
Display results of formula 1
large formula question - Max nested functions 3
Convert Decimal fractions to binary and vice versa 1
How to return a cell reference as result of a formula 2
INDEX return multiple columns 1

Back
Top