There are I suspect several ways, one would be to create a table in for
example Sheet 2 with column A containing 'A to Z' ,(A1:A26), column B
containing the values you want to assign to each letter (B1:B26)
Then if your blank cell were Sheet1A1, then in B1 enter :-
=VLOOKUP(A1,Sheet2!$A$1:$B$26,2,False)
Regards,
"Tykelad" wrote in message
...
Is it possible for letters to have a value ?
E.G Imagine a blank cell. If i enter the letter M in it, i want the cell
next to it to show the number 8. If i enter the letter A, i want the
adjacent
cell to show the number 11 etc etc
Can anyone help me ?