Thread: recognizing words as numbers...for a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
confused confused is offline
external usenet poster
  
Posts: 193
Default recognizing words as numbers...for a formula
I want excel to recognize "light" as a value of 60 but show the text not the
value. Then I want to use this cell in a formula. Any idea how to do that?
Reply With QuoteReply With Quote