how do I convert numeric value to its character value ex. 10=Ten

[Shreesh Asthana]

Please suggest me how do I convert a numeric value to its character value.
for example
1 = one
2 = two
3 = three
4 = four
5 = five

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)