how do you change a digit to alpha (2 = two)
 

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

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

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

.

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??