View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tom Tom is offline
external usenet poster
 
Posts: 2
Default convert text to number

Novice excel 2007 user just can't working for days on this please help. can
you please tell me how to convert single text in one cell to a number in
another cell, example i need the letter W converted to number 6
the letter L converted to number 0, and H to be half the value i assign to
it. any help would be great apprecieated. Thanks Tom--
tom naz