Take a look at these sites:

http://support.microsoft.com/default...b;en-us;213360

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

http://www.ozgrid.com/VBA/ValueToWords.htm

"Shahrun A Rahman" wrote:

I have to prepare an invoice where beside stating the value of the invoice, I
also have to type the value in words. An axample is $1,234.50 and it will be
converted to "One Thousand Two Hundred Thirty Four and Cent Fifty"