convert figure into word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ankur - 24 Jun 2006 13:25 GMT

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

Reply to this Message

somethinglikeant - 24 Jun 2006 14:06 GMT

useful link:-

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

somethinglikeant

> Hi,
>
[quoted text clipped - 8 lines]
> Regards,
> Ankur

Reply to this Message

Jaleel - 25 Jun 2006 13:13 GMT

Click this URL and you will get Macro:

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

> useful link:-
>
[quoted text clipped - 13 lines]
> > Regards,
> > Ankur

Reply to this Message

Afzal Iqbal - 13 Jul 2007 07:50 GMT

> Hi,
>
[quoted text clipped - 8 lines]
> Regards,
> Ankur

Reply to this Message

anne asha jyothi - 28 Mar 2008 06:46 GMT

> Hi,
>
[quoted text clipped - 8 lines]
> Regards,
> Ankur

Reply to this Message