Hi everyone.
I really need someone to help me out with this basic function:

On microsoft excel, I need a LETTER (ALPHABET) in a cell to be
converted to a numerical value automatically.

EXAMPLE:

WHEN CELL A1 RECIEVES RECIEVES THE LETTER: N, I want that to change (or
another cell to change) to the number 5.

AND WHEN CELL A1 RECIEVES RECIEVES THE LETTER: Y, I want that to change
(or another cell to change) to the number 10.

What do you reckon?

NB: please dont suggest manual things like the find replace, I am to
lazy for that.
I want something really streamlined!!

rish


--
reloadinternet
------------------------------------------------------------------------
reloadinternet's Profile: http://www.excelforum.com/member.php...o&userid=26505
View this thread: http://www.excelforum.com/showthread...hreadid=397745