|
| 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 20th, 2010, 05:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you change a digit to alpha (2 = two)
|
|
#2
May 20th, 2010, 07:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you change a digit to alpha (2 = two)
On May 20, 12:20*pm, cindymichaels
wrote: For a single digit, consider using VLOOKUP(). If D1 thru E10 contain: 0 zero 1 one 2 two 3 three 4 four 5 five 6 six 7 seven 8 eight 9 nine Then =VLOOKUP(A1,D1:E10,2,FALSE) will return rwo if A1 contains 2
|
|
#3
May 20th, 2010, 08:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you change a digit to alpha (2 = two)
Does this mean your studies with Gary are now complete?
g Gord On Thu, 20 May 2010 11:31:55 -0700 (PDT), James Ravenswood wrote: On May 20, 12:20*pm, cindymichaels wrote: For a single digit, consider using VLOOKUP(). If D1 thru E10 contain: 0 zero 1 one 2 two 3 three 4 four 5 five 6 six 7 seven 8 eight 9 nine Then =VLOOKUP(A1,D1:E10,2,FALSE) will return rwo if A1 contains 2
|
|
#4
May 20th, 2010, 11:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you change a digit to alpha (2 = two)
Using James allows me to answer posts thru Google.
How did you derive the connection between James and GS?? -- Gary''s Student - gsnu201003 "Gord Dibben" wrote: Does this mean your studies with Gary are now complete? g Gord On Thu, 20 May 2010 11:31:55 -0700 (PDT), James Ravenswood wrote: On May 20, 12:20 pm, cindymichaels wrote: For a single digit, consider using VLOOKUP(). If D1 thru E10 contain: 0 zero 1 one 2 two 3 three 4 four 5 five 6 six 7 seven 8 eight 9 nine Then =VLOOKUP(A1,D1:E10,2,FALSE) will return rwo if A1 contains 2 .
|
|
#5
May 24th, 2010, 11:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you change a digit to alpha (2 = two)
Just some little hints that have turned up over the years.
Gord On Thu, 20 May 2010 15:03:01 -0700, Gary''s Student wrote: Using James allows me to answer posts thru Google. How did you derive the connection between James and GS??
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
