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"

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"

Hello,

I suggest to use
http://www.sulprobil.com/html/spellnumber.html

My function offers more parameter checks than others (test other
suggestions with input values shown on my page).

It is being used in banks but read my disclaimer, please.

Regards,
Bernd