View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Papa Jonah Papa Jonah is offline
external usenet poster
 
Posts: 148
Default formulas appearing as text instead of computing

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