Convert a number into words

[evdokimos]

Hi all

Is there any function that can convert a number into words eg 125 is converted into ONE HUNDRED TWENTY FIVE or should I create one using VBA?

Thanks for your help.

Evdokimos

 

[daniels012]

No and Yes
Not normally, I should say
You can go to the to of the Excel Questions page where Von Pookie has a Message about: Recommended AddIns

Select the one that says:
MOREFUNC

This guy has developed a great tool to do just that.

Hope that helps,
Michael

 

[Tom Urtis]

Click the Search link, and search for all terms
"convert and numbers and words" (without the quotes)
for a couple dozen examples on this oft-answered question.

 

[daniels012]

That is so true TOM,

You would think Microsoft would just create the function!!!


Michael