View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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?