How to convert digits into text
 

Eg. 10 should be converted as "Ten"

How to convert digits into text
 

Bob Phillips shows two ways of doing this on his site:

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

Hope this helps.

Pete

On Aug 19, 7:06*am, Naseem wrote:
Eg. *10 * should be converted as *"Ten"

How to convert digits into text
 

If your requirement is not vast you can use lookup as below, where you would
enter a number in F1. Don't know the limits of it though.

=LOOKUP(F1,{1,2,3,4},{"One","Two","Three","Four"})

HTH
Regards,
Howard

"Naseem" wrote in message
...
Eg. 10 should be converted as "Ten"