G'day Tykelad,
Just a FYI
I cannot directly assist, as I am a plodder in Excel :)
however, In MSWorks I have a fields that use exactly your request
and I use a "Choose" statement.
The employment of this, depends on the number of characters
one can fit in a cell.
Otherwise VLookup is used.
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 ?