Rendering Numbers into Written Words

[John]

Is there a function or formatting code that will take numbers and convert
them into written words ie: "42" becomes "forty-two"

 

[Pete_UK]

Bob Phillips shows different ways to do this here:

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

Hope this helps.

Pete