View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam Adam is offline
external usenet poster
 
Posts: 287
Default HOW CAN A LETTER IE A ,B OR C REPRESENT A NUMBER IE 0.5 OR 2 ETC..

I wanted know how can I make a letter ie A or B represent a number, in this
case I wanted all characters represent 0.5. This is to add them all up. At
the end I wanted to collectively sum up how many As, Bs etc.. in numbers:

Mon Tues Wed A=1 B=0.5 etc...
J G A
B H C
N S A
---------------------------
1.5 1.5 1.5