| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you change a digit to alpha (2 = two)
|
|
#2
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
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
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
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I CHANGE TO ALPHA HEADER IN 2007 | Excel Discussion (Misc queries) | |||
| How can I change column headers from numeric to alpha? | Excel Discussion (Misc queries) | |||
| change a list of 2 digit years to 4 digit years? | Excel Worksheet Functions | |||
| Change second digit from 4 to 6 | Excel Worksheet Functions | |||
| sorting alpha numeric list by first left digit | New Users to Excel | |||
Hybrid Mode
