v07 cell shows formula string literal not value returned from formula

G

GiJeet

Hi, I've used excel before but not version 2007. I have entered a
formula, starting with an equal sign. Formula is not enclosed in
quotes and the cell only displays the formula, not the value returned
from the formula. WTF?? In all previous version, I had no problem
display the results of the formula. Is there something new in 2007
that I am missing? Please help.

TIA
G
 
M

MikeS

Hi, I've used excel before but not version 2007.  I have entered a
formula, starting with an equal sign.  Formula is not enclosed in
quotes and the cell only displays the formula, not the value returned
from the formula. WTF??  In all previous version, I had no problem
display the results of the formula.  Is there something new in 2007
that I am missing?  Please help.

TIA
G

I've had that problem in 2003 before (haven't used 2007 yet), and the
problem was the cell format was Text (under Format > Cells | Number >
Category). Using Text format with a formula isn't a good idea.

Otherwise You have to do a find & replace for the formula to show.
 

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

Top