J John Nov 30, 2007 #1 Is there a function or formatting code that will take numbers and convert them into written words ie: "42" becomes "forty-two"
Is there a function or formatting code that will take numbers and convert them into written words ie: "42" becomes "forty-two"
P Pete_UK Nov 30, 2007 #2 Bob Phillips shows different ways to do this here: http://www.xldynamic.com/source/xld.xlFAQ0004.html Hope this helps. Pete
Bob Phillips shows different ways to do this here: http://www.xldynamic.com/source/xld.xlFAQ0004.html Hope this helps. Pete