convert figure into word
 

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

convert figure into word
 

useful link:-

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


somethinglikeant
Ankur wrote:
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

convert figure into word
 

Click this URL and you will get Macro:

http://support.microsoft.com/default...;EN-US;Q213360

"somethinglikeant" wrote:

useful link:-

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


somethinglikeant
Ankur wrote:
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

convert figure into word
 

"Ankur" wrote:

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

convert figure into word
 

"Ankur" wrote:

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

convert figure into word
 

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

"anne asha jyothi" wrote:



"Ankur" wrote:

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