This has driven me insane for years! I type =a14+a15 and the cell display is
=a14+a15. Instead of treating it as a function and providing a result I only
see the formula displayed as text within the cell. The above calc was just a
sample and I usually find a way around it but this happens to me more and
more often. Any help would be appreciated..


--
Ray

hi Ray,

try:

1. check if the cell is formated as text, format it as general and try again.

2. Tools | Options | exibity box and uncheck formula

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Ray" escreveu:

This has driven me insane for years! I type =a14+a15 and the cell display is
=a14+a15. Instead of treating it as a function and providing a result I only
see the formula displayed as text within the cell. The above calc was just a
sample and I usually find a way around it but this happens to me more and
more often. Any help would be appreciated..


--
Ray

You need to do two things prior to entering a formula:


1. Insure that Tools Options... View and Formulas is un-checked
2. Insure that the cell is not formatted to Text
--
Gary's Student


"Ray" wrote:

This has driven me insane for years! I type =a14+a15 and the cell display is
=a14+a15. Instead of treating it as a function and providing a result I only
see the formula displayed as text within the cell. The above calc was just a
sample and I usually find a way around it but this happens to me more and
more often. Any help would be appreciated..


--
Ray