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

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

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

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)

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