G Guest Oct 10, 2005 #1 How can I create a function to do this? A1 1 One A2 2 Two A3 3 Three A4 4 Four A5 5 Five A6 6 Six .......
How can I create a function to do this? A1 1 One A2 2 Two A3 3 Three A4 4 Four A5 5 Five A6 6 Six .......
B Bob Phillips Oct 10, 2005 #2 Depends on the complexity. If just single digits, use =CHOOSE(A1,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") If more complex, see http://www.xldynamic.com/source/xld.xlFAQ0004.html
Depends on the complexity. If just single digits, use =CHOOSE(A1,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") If more complex, see http://www.xldynamic.com/source/xld.xlFAQ0004.html
