Thread: Formula shows in cell instead of results (text reference)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Formula shows in cell instead of results (text reference)
Entering a formula in a cell that is formated text gives you test, not a
formula. Try formating A106 as general then reenter the formula and see if
that works.

Tom
Reply With QuoteReply With Quote