converting number to words
 

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

converting number to words
 

Look he

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


"Prashant Mhapankar" wrote:

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

converting number to words
 

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.

"Toppers" wrote:
Look he

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


"Prashant Mhapankar" wrote:

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

converting number to words
 

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