Formula display - no results

W

Wannano

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!
 
D

Dave Peterson

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
 
V

Vergel Adriano

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.)
 
Top