Dear Sir,

I am still facing the problem. Can you send me some file in which this
formula is used and also guide me how i can incorporate this in my worksheet
because as advised by you, I had tried by pussing ALT + F9 but nothing is
appearing.

Your early reply will be highly appreciated and hope will help me a lot

Thanks & Regards

Pradeep Kapoor


"Bernd" wrote:

Hello,

I suggest to take my user-defined-function spellnumber:
http://www.sulprobil.com/html/spellnumber.html

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

You have to insert this function into a macro module: press ALT + F9,
insert module, copy text into module and get back to your worksheet.

And if you get other suggestions, I strongly recommend to test all of
them with test values given on my homepage and compare.

Regards,
Bernd