Bob Phillips shows different ways to do this he

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

Hope this helps.

Pete

On Nov 30, 3:44 pm, John wrote:
Is there a function or formatting code that will take numbers and convert
them into written words ie: "42" becomes "forty-two"
--
John