converting number to words

[Prashant Mhapankar]

hot to convert numeric number to word ?
e.g. 10 to TEN

 

[Toppers]

Look here:

http://xldynamic.com/source/xld.xlFAQ0004.html

 

[Prashant Mhapankar]

Thanks for the following.

But i require plain conversion...the link provides conversion to Currency
mode.
Please help for getting code for convertion just plain number to words

e.g. 115225 = ONE LAKH FIFTEEN THOUSAND TWO HUNDRED TWENTY FIVE

I AM NOT EXPERT IN MODIFYING THE CODE SO PLEASE HELP.

 

[Bernd P]

Hello,

You can ignore currency info this way:
=LEFT(spellnumber(A1),FIND(" Dollar",spellnumber(A1))-1)

I suggest to take my UDF spellnumber:
http://www.sulprobil.com/html/spellnumber.html

If you want to try other programs published in the web I suggest to
test them with input -1.

Regards,
Bernd