Convert Numbers to Text
 

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

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

--
HTH

Bob Phillips

"cradino" wrote in message
...
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
.......