formulas appearing as text instead of computing

  • Thread starter Thread starter Papa Jonah
  • Start date Start date
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
 
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.
 
Hi,

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

Thanks,
 
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.
 
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

Storing formula in cell 14
Salary by Qtr Formula 1
Formula appearing instead of result 2
formula 3
Frequency 5
Cell showing formula instead of date 6
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formula 5

Back
Top