I wanted to enter a number in a cell for example 10 in A2 and this number
should be converted into a letter say "A"in A2 cell. How could it be done?

Setup a table somewhere definining what values correspond to what output,
and then use a VLOOKUP/LOOKUP function.

=VLOOKUP(A2,My_Table,2,FALSE)

--
Best Regards,

Luke M
"Raja" wrote in message
...
I wanted to enter a number in a cell for example 10 in A2 and this number
should be converted into a letter say "A"in A2 cell. How could it be
done?

Could you please elaborate your requirement..What if you type something else
other than 10.

If you just want any number typed into cell A2 to be displayed as A; then
custom format the cell as below

"A"

--
Jacob (MVP - Excel)


"Raja" wrote:

I wanted to enter a number in a cell for example 10 in A2 and this number
should be converted into a letter say "A"in A2 cell. How could it be done?