Thread: Letter represents a number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M Kan M Kan is offline
external usenet poster
  
Posts: 169
Default Letter represents a number
If you have a larger list of letter-value combos, you might just want to
create a lookup table and then use a vlookup for the translation.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"JRD920" wrote:

I would like to have a letter represent a number and to be able to calculate
to get a sum.

Example X= ".5" = 0.5
Reply With QuoteReply With Quote