There is no direct functions to convert this. For a VBA solution check out
the below links

http://support.microsoft.com/kb/213360
http://www.ozgrid.com/VBA/ValueToWords.htm
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Jacob (MVP - Excel)


"Kiley" wrote:

What is the formula to convert numbers to words?

Example:

Number Words
568 Five Hundred Sixty Eight