Try this:
http://www.ozgrid.com/VBA/ValueToWords.htm
*******************
~Anne Troy
www.OfficeArticles.com
"nivedrajesh" wrote in message
...
I entered the amount 125 in the cell A1. I want excel to convert the
value
in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say
A2. The value in words should change automatically when I change the
amount.
Is there any formula for this? can any one help?