Hi,
I tried it and it really works. Going a step forward, I want to be able to
use this function for all new workbooks which I am going to create in future.
How can I do this, pls reply.

Thanks in anticipation.

"Mike" wrote:

This function courtesy of Microsoft re-published below seems to be the
favoured option.

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


"Converting number to text in Excel" wrote:


i like to convert the number say USD.250/- to US Dollars Two Hunderd and
Fifty only . How Can I Do This Function in Excel I tried the Formula
=Bahttext(250) but it comes in some other language