Eg. 10 should be converted as "Ten"
P Pete_UK Aug 19, 2008 #2 Bob Phillips shows two ways of doing this on his site: http://www.xldynamic.com/source/xld.xlFAQ0004.html Hope this helps. Pete
Bob Phillips shows two ways of doing this on his site: http://www.xldynamic.com/source/xld.xlFAQ0004.html Hope this helps. Pete
L L. Howard Kittle Aug 19, 2008 #3 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
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
