Formula showing in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a formula that I entered in a cell but instead of the results the
formula is showing in the cell.

How can I get the results to show.

Thanks.
 
Hi
- check that this cell is not formated as 'Text' (Format - Cells').
Change the format to 'General' and re-enter your formula

- check in 'tools - Options - View' that 'Formula' is unchecked
 
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

Formula result disappeared 5
Excel Formulas 3
Excel VBA 1
Formula text in woorksheet cell 2
how do i show the calculated value in a cell rather than formula 3
Formula result showing 0 3
Excel 2007 Not returning formula result 2
Editing a formula 11

Back
Top