Convert Numbers to Text

[Guest]

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

 

[Bob Phillips]

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