convert figure into word

[Ankur]

Hi,

I am working in accounts dept and have to prepare excel invoices daily. I
have to write the total amount of invoice both in figures and words, right
now i m manually writing the amount in words. Is there any formula to convert
the figures to words? The amount to be written in USD for eg. Two thousand
fifty and 50/100 cents.

Many thanks in advance.

Regards,
Ankur

 

[somethinglikeant]

useful link:-

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

 

[Jaleel]

Click this URL and you will get Macro:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360

 

[Afzal Iqbal]

Hi,

I am working in accounts dept and have to prepare excel invoices daily. I
have to write the total amount of invoice both in figures and words, right
now i m manually writing the amount in words. Is there any formula to convert
the figures to words? The amount to be written in USD for eg. Two thousand
fifty and 50/100 cents.

Many thanks in advance.

Regards,
Ankur

 

[anne asha jyothi]

Hi,

I am working in accounts dept and have to prepare excel invoices daily. I
have to write the total amount of invoice both in figures and words, right
now i m manually writing the amount in words. Is there any formula to convert
the figures to words? The amount to be written in USD for eg. Two thousand
fifty and 50/100 cents.

Many thanks in advance.

Regards,
Ankur

 

[Mita]

i get result in dollar but i want the result in rupee