View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Alphbet to number conversion

Wrong thread ! ! !


--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"RagDyeR" wrote in message
...
One way:

=CEILING(D2*0.8,1)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"rk0909" wrote in message
...
Hello,

I want to create a formula where the input is an alphbet representing a
column (e.g. S) but i want that to be interpretted as a number corresponding
to the alphabets rank (20 in this case). Is there a conversion formula that
exists?

thanks,

RK