Formula display - no results

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

Guest

I have a formula in a cell, but it did not calculate; however it displayed
the formula as though I had typed in text. Does anyone know what the problem
might be? My Excel is set up to calculatie automatically.

Thanks!
 
A couple of things to try.

Format the cell as General and reenter the formula.

Make sure you don't have any spaces in front of the leading equal sign.

Make sure you aren't looking at formulas:
tools|options|view tab|Uncheck formulas
 
Two possible reasons:

1. The cell is formatted as Text (Format->Cells then check the format in
Number tab)
2. You have set the option to show formulas (Tools->Options then in the View
tab, make sure "Formulas" is not checked.)
 
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 displays as formula, not as result 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
copying formulas-displaying results 1
Excel Formula displays text of formula 2
Formula result not displaying correctly 2
Excel Stop Excel from displaying rounded values 4
Displaying results in formula bar when cell is hidden 1
Cell shows the last typed text, no matter where it is typed 0

Back
Top