Thread: formula remains as text rather than formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default formula remains as text rather than formula
If the formula references a cell that is formatted as text this can also
happen.

--
Regards,
Tom Ogilvy

"kkknie " wrote in message
...
If the cell is formatted as text, this will happen. Change to general
and reenter the formula and it should work.

K


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote