Convert currency into words

Good Morning guys,

I show one macro with the above subject and it is absolute i need but i need to put the currency word beside (red color) the number like below
123.5 = One Hundred Twenty Three Dirhams and 50/100 fils.
.50 = 50/100 fils.

the previous macro i saw is 123.5 = one hundred twenty three and 50/100 only without the currency word.

Can you help me please

thanks in advance

I suggest you to make use of the NB.TEXT Function of Morefunc addin which is more user friendly.

You can get the Morefunc Addin by doing a google search.

Try the function at bottom of this post.
Call function as follows:

Please Login or Register  to view this content.

It works for me.

Please Login or Register  to view this content.

This is a bit rough but it should work

Please Login or Register  to view this content.

Originally Posted by jocer

thanks mate ur genius...... how to close this query already solved.

Thank you for the compliment but I don't deserve that. There was already existing code out there that did almost what you wanted. All I had to do was edit this code to have the output return in your desired format.

It looks like you have worked out how to solve the query.