Hi Alex

jason has answered you in microsoft.public.excel.worksheet.functions
it is generally not necessary to ask the same question in more than one
group as most of the responders read a number of different groups and doing
this tends to fragment your answers.

cheers
JulieD

"Alex" wrote in message
...
How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2.