View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
rahrah3a rahrah3a is offline
external usenet poster
 
Posts: 2
Default 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?