There's a NumsToWords() user defined function (UDF) file you can
download at this website:
http://www.contextures.com/excelfilesRon.html

The NumsToWords() function allows you to set the major currency (eg
Dollars),
the minor currency (eg Cents) and the word that connects the major and minor
currencies (eg And).

The file is completely unprotected, so you have full access to all of the
VBA code. The cover sheet in that file has instructions, several usage
examples AND a button that will export the NumsToWords program into any open
workbook you choose.

There's also a NON-VBA NumsToWords approach at that website.

Other sites that may be of interest:
http://support.microsoft.com/default...b;en-us;213360
http://www.ozgrid.com/VBA/ValueToWords.htm
http://xldynamic.com/source/xld.xlFAQ0004.html

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"gsreddy" wrote in message
...