Prev: Define a Value
Next: Separate Date from a Text String
From: Raja on 18 May 2010 09:19
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?
From: Luke M on 18 May 2010 09:42
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" <Raja(a)discussions.microsoft.com> wrote in message
news:3C9AB841-6090-450B-A31A-4E7FF0B2DE0D(a)microsoft.com...
>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?


From: Jacob Skaria on 18 May 2010 10:13
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?
 | 
Pages: 1
Prev: Define a Value
Next: Separate Date from a Text String