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

[cindymichaels]

 

[James Ravenswood]

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

 

[Gord Dibben]

Does this mean your studies with Gary are now complete?

<g>


Gord

 

[Gary''s Student]

Using James allows me to answer posts thru Google.

How did you derive the connection between James and GS??

 

[Gord Dibben]

Just some little hints that have turned up over the years.


Gord