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

J

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
 
G

Gary''s Student

Using James allows me to answer posts thru Google.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number to word 4
Return a name in the same row 3
creating nested formulas from drop down box 5
Numaric to Inword in excel by VB 1
Barcode Check Digits 3
How do you change single digits to recognized double digits? 4
Averaging values from a list, based on user input 3
How do I calculate a check-digit in Excel? 5

Top