when i type a formula in excel i can see the formula only

  • Thread starter Thread starter Santhosh
  • Start date Start date
In Excel 2003 go to Tools->Options->View Tab

Uncheck the 'Formulas' checkbox in the Windows Options block...

OR

You can press (once only) CTRL-~ keys together :-)
 
You are right, David. My mistake...

David Biddulph said:
On my keyboard it is Ctrl `, not Ctrl ~

Another possible explanation is that the cell may be formatted as text. If
so, format as general and then re-enter the formula.
Click to expand...
 
You must log in or register to reply here.

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

COPY FORMULA 2
Document numbering in Excel 1
Suddently when we type in . (dot or point) become comma in excel 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Forcing Second Line in Excel 2
How do I set up the Bisection method in Excel? 1
What is "--" in Excel Formula (SUMPRODUCT) 2
I need to round in the middle of a formula 1

Back
Top