converting number to words

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Prashant Mhapankar - 18 Jun 2007 11:35 GMT

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

Reply to this Message

Toppers - 18 Jun 2007 11:49 GMT

Look here:

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

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

Reply to this Message

Prashant Mhapankar - 19 Jun 2007 05:35 GMT

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.

> Look here:
>
> http://xldynamic.com/source/xld.xlFAQ0004.html
>
> > hot to convert numeric number to word ?
> > e.g. 10 to TEN

Reply to this Message

Bernd P - 19 Jun 2007 05:48 GMT

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

Reply to this Message