formula is text, not resolving to an answer
 

when I type in a formula, by example =2+4 and hit enter, the cell displays
the text of =2+4 and does not resolve into a 6. How can I correct?

formula is text, not resolving to an answer
 

Sounds like the cell is formatted to text. Reformat the cell to number and
type it in again.

Format|Cell then select the number tab and choose number.

"rahrah3a" wrote:

when I type in a formula, by example =2+4 and hit enter, the cell displays
the text of =2+4 and does not resolve into a 6. How can I correct?

formula is text, not resolving to an answer
 

Try going up in the formula bar and deleting the equal sign and hit
enter.....then replace the equal sign and hit enter again..........

Possibly the cell was pre-formatted as TEXT.

Vaya con Dios,
Chuck, CABGx3


"rahrah3a" wrote:

when I type in a formula, by example =2+4 and hit enter, the cell displays
the text of =2+4 and does not resolve into a 6. How can I correct?

formula is text, not resolving to an answer
 

Thank you. Simply formating the cell to a number did not work, deleting the
equal and re-adding it worked perfectly. Thanks!

"CLR" wrote:


Try going up in the formula bar and deleting the equal sign and hit
enter.....then replace the equal sign and hit enter again..........

Possibly the cell was pre-formatted as TEXT.

Vaya con Dios,
Chuck, CABGx3


"rahrah3a" wrote:

when I type in a formula, by example =2+4 and hit enter, the cell displays
the text of =2+4 and does not resolve into a 6. How can I correct?

formula is text, not resolving to an answer
 

Happy to help, thanks for the feedback............

Vaya con Dios,
Chuck, CABGx3



"rahrah3a" wrote:

Thank you. Simply formating the cell to a number did not work, deleting the
equal and re-adding it worked perfectly. Thanks!

"CLR" wrote:


Try going up in the formula bar and deleting the equal sign and hit
enter.....then replace the equal sign and hit enter again..........

Possibly the cell was pre-formatted as TEXT.

Vaya con Dios,
Chuck, CABGx3


"rahrah3a" wrote:

when I type in a formula, by example =2+4 and hit enter, the cell displays
the text of =2+4 and does not resolve into a 6. How can I correct?