|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 18th, 2010, 02:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
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? 
|
|
#2
May 18th, 2010, 02:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas
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?
|
|
#3
May 18th, 2010, 03:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
