formulas appearing as text instead of computing

P

Papa Jonah

We recently changed all of our computers and I am apparently struggling with
new settings. In Excel, I am entering formulas such as =if(Q5=Q4,x,"").
In the cell, it is showing up as entered instead of an "x", "", or some sort
of error.
To further test it, I entered =1+1 into a cell and I did not get 2, but
"=1+1" is visible in the cell.
What setting needs to be fixed?
TIA Papa
 
D

David Biddulph

Tools/ Options/ View:
uncheck Formulas.

If it isn't that, make sure that you don't have the cells formatted as text.
If they are formatted as text, change to general and then re-enter the
formula.
 
S

sudarsan

Hi,

This is the path,
Tools - Options - in View tab - Under windows options - uncheck Formulas
check box

Thanks,
 
W

Warren Easton

If you're using Excel 2007 try the Formulas tab in the Formula Auditing box
there's a Show Formulas option you may have to uncheck this.
 
Top