Fwd: Excel Add-in to convert amount in figures to words
7,272 views
Skip to first unread message
rahul bajaj
Nov 8, 2005, 2:54:51 AM11/8/05
to Nasik CAs
Note: forwarded message attached.
Yahoo! India Matrimony: Find your partner now.
YAHOO! GROUPS LINKS
- Visit your group "witty_chartereds" on the web.
- To unsubscribe from this group, send an email to:
witty_chartere...@yahoogroups.com
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Bhalchandra Kale
Nov 9, 2005, 10:41:34 AM11/9/05
to nashikst...@googlegroups.com
Will you please resend the attachement?
On 08/11/05, rahul bajaj <rpbaja...@yahoo.com> wrote:
>
> Note: forwarded message attached.
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> ---------- Forwarded message ----------
> From: Nayana Chawla <nay_c...@yahoo.com>
> To: ajayom...@yahoo.co.in
> Date: Fri, 16 Sep 2005 06:55:30 +0100 (BST)
> Subject: Fwd: IndianCAs: Excel Add-in to convert amount in figures to words
> Note: forwarded message attached.
>
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com
>
>
> ---------- Forwarded message ----------
> From: plm...@vsnl.com
> To: indi...@yahoogroups.com
> Date: Sat, 10 Sep 2005 16:56:34 +0500
> Subject: IndianCAs: Excel Add-in to convert amount in figures to words
>
>
>
>
> Gentlemen:
>
> AmtInWords.xla is attached to this mail. It is an MS Excel Add-in written by
> me to convert amount available in figures to words.
>
> Installation
> Copy the attached file to the folder where excel stores the add-ins. (To
> know where excel stores the add-ins, open any workbook, click on Tools -
> Add-ins - Browse)
> Then open an excel workbook. Click on Tools - Add-ins - Browse - Give the
> path to this Addin - Ok
>
> Usage
>
> You can use the functions AmtInWords and AmtInWordsUS in any worksheet. The
> syntax is:
>
> =AmtInWords(decimal number/cell reference, [currency code])
>
> =AmtInWordsUS(decimal number/cell reference, [currency code])
>
> Examples follow:
>
> =AmtInWords(10000000)
>
> =AmtInWords(123456.77)
>
> =AmtInWords(C4)
>
> =AmtInWordsUS(B3) ' Shall give the amount in millions (US format)
>
> =AmtInWordsUS(B3,"USD") ' Shall give the amount in millions (US format) and
> in US currency (Dollars)
>
> =AmtInWords(C4,"GBP") ' Shall give the amount in lakhs and in UK currency
> (Pounds)
>
> Notes
>
> The system shall NOT give you any warning/error if you use:
>
> =AmtInWords(C4,"USD") ' Amount in lakhs and in US currency (Dollars)
>
> OR
>
> =AmtInWordsUS(C4,"GBP") ' Amount in millions and in UK currency (Pounds)
>
>
>
> At present 3 currency codes are supported:
> INR (the default ... not required to be given separately)
> USD
> GBP
>
> Let me know how you find it and/or your suggestions.
>
> Regards
>
> Premal
>
>
>
>
--
Regards,
for B G Kale & Co
Chartered Accountants
On 08/11/05, rahul bajaj <rpbaja...@yahoo.com> wrote:
>
> Note: forwarded message attached.
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> From: Nayana Chawla <nay_c...@yahoo.com>
> To: ajayom...@yahoo.co.in
> Date: Fri, 16 Sep 2005 06:55:30 +0100 (BST)
> Subject: Fwd: IndianCAs: Excel Add-in to convert amount in figures to words
> Note: forwarded message attached.
>
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com
>
>
> ---------- Forwarded message ----------
> From: plm...@vsnl.com
> To: indi...@yahoogroups.com
> Date: Sat, 10 Sep 2005 16:56:34 +0500
> Subject: IndianCAs: Excel Add-in to convert amount in figures to words
>
>
>
>
> Gentlemen:
>
> AmtInWords.xla is attached to this mail. It is an MS Excel Add-in written by
> me to convert amount available in figures to words.
>
> Installation
> Copy the attached file to the folder where excel stores the add-ins. (To
> know where excel stores the add-ins, open any workbook, click on Tools -
> Add-ins - Browse)
> Then open an excel workbook. Click on Tools - Add-ins - Browse - Give the
> path to this Addin - Ok
>
> Usage
>
> You can use the functions AmtInWords and AmtInWordsUS in any worksheet. The
> syntax is:
>
> =AmtInWords(decimal number/cell reference, [currency code])
>
> =AmtInWordsUS(decimal number/cell reference, [currency code])
>
> Examples follow:
>
> =AmtInWords(10000000)
>
> =AmtInWords(123456.77)
>
> =AmtInWords(C4)
>
> =AmtInWordsUS(B3) ' Shall give the amount in millions (US format)
>
> =AmtInWordsUS(B3,"USD") ' Shall give the amount in millions (US format) and
> in US currency (Dollars)
>
> =AmtInWords(C4,"GBP") ' Shall give the amount in lakhs and in UK currency
> (Pounds)
>
> Notes
>
> The system shall NOT give you any warning/error if you use:
>
> =AmtInWords(C4,"USD") ' Amount in lakhs and in US currency (Dollars)
>
> OR
>
> =AmtInWordsUS(C4,"GBP") ' Amount in millions and in UK currency (Pounds)
>
>
>
> At present 3 currency codes are supported:
> INR (the default ... not required to be given separately)
> USD
> GBP
>
> Let me know how you find it and/or your suggestions.
>
> Regards
>
> Premal
>
>
>
>
--
Regards,
for B G Kale & Co
Chartered Accountants
rahul bajaj
Nov 11, 2005, 12:56:54 AM11/11/05
to nash...@googlegroups.com
Note: forwarded message attached.
Yahoo! India Matrimony: Find your partner now.
YAHOO! GROUPS LINKS
- Visit your group "witty_chartereds" on the web.
- To unsubscribe from this group, send an email to:
witty_chartere...@yahoogroups.com
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Reply all
Reply to author
Forward
0 new messages