Cell returning actual function syntax (=sum.....) instead of result

D

dlel

I'm using the sum function and my cells are displaying the
syntax, i.e., =sum(c3/c2), instead of the result it s/b
returning. I've already checked Tools/Options/View and the
box in front of Formulas is unchecked, so that's not it.

Thanks in advance for your help!
 
F

Frank Kabel

Hi
your cell is probably formated as 'Text'. Select the cell and goto
'Format - Cells'. Change the format to 'General' and re-enter your
formula
 
D

dlel

Thank you so much!!
-----Original Message-----
Hi
your cell is probably formated as 'Text'. Select the cell and goto
'Format - Cells'. Change the format to 'General' and re- enter your
formula

--
Regards
Frank Kabel
Frankfurt, Germany



.
 

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