Skip to main content

Excel Add-in to convert amount in figures to words by Premal

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

Comments

  1. Indeed very useful formula.

    ReplyDelete
  2. Indeed very useful formula.

    ReplyDelete
  3. Million thanks to Premal Mehta. I have tried and tested, it is a wonderful add-in.
    Bharat Desai - CA.

    ReplyDelete
  4. Anonymous4:02 PM

    I not seen any attached file with this post. Please send me the attached file.

    Gopal Garg

    ReplyDelete
  5. Anonymous7:29 PM

    I have not received any attached file with mail. You are requested to attechment again to help me.
    Hinabshu V. Shah

    ReplyDelete
  6. Anonymous9:12 PM

    Hi Ashwin !! i wasn't able to see the file. can u pls e mail the same.

    regards
    Saurabh

    ReplyDelete
  7. Anonymous10:44 PM

    Gopal/Hinabshu/Saurabh:

    If you still haven't received the file, you may send me a request at plmehta@vsnl.com ... I shall forward another copy of the message with the attachment.

    Regards
    Premal

    ReplyDelete
  8. Anonymous4:47 AM

    I too have not received the file as an attachment.Could you also consider writing an addin to convert figures into Indian Rupees format i.e.,lakhs crores etc with a button to be attached to the toolbar. Behram H.Chhapgar

    ReplyDelete
  9. Anonymous6:46 PM

    I too have not received the attachment. could you send me the same an oblige me on email address sandeepjsinghal@hotmail.com
    Sandeep

    ReplyDelete
  10. Anonymous1:01 PM

    I too have not received any attachment if you send it on my ID
    dybhatt@rediffmail.com

    ReplyDelete
  11. Anonymous1:15 PM

    I have not seen any attachment.Pl send in the following address:
    pjm@ambujamail.com

    ReplyDelete
  12. Anonymous12:40 PM

    I have not seen any attachment. plz send in the following address :

    sushilarora30@yahoo.co.in

    ReplyDelete
  13. Anonymous12:23 PM

    can you send me the attachment to at ravisankar30@gmail.com

    ReplyDelete
  14. Please send me this utility to nasluck@yahoo.com

    ReplyDelete
  15. Anonymous10:44 PM

    please e mail me on ID

    madan.vaishnawa@gmail.com

    ReplyDelete
  16. Anonymous2:27 AM

    kindly send it to me also at palshotelmumbai@yahoo.co.in
    thx alot Pals Hotel

    ReplyDelete
  17. Anonymous8:49 PM

    kindly semd me the file.

    thanks

    goenkapankaj@yahoo.com

    ReplyDelete
  18. Anonymous9:05 PM

    Please send Amtinwords.xla file to the email id : dayanand27@rediffmail.com

    ReplyDelete
  19. Anonymous12:44 PM

    Could you please email the file to bhandarigaurav@gmail.com.

    Thanks

    ReplyDelete
  20. Anonymous6:49 PM

    pls send the attachment to vikasagarwal77@yahoo.co.in

    ReplyDelete
  21. Anonymous1:15 PM

    Please send the attachmment to adibedekar@yahoo.com

    ReplyDelete
  22. Paresh7:33 PM

    Hi
    I m Paresh here
    I m doing articleship in pune
    I read yr Excel Add-in to convert amount in figures to words
    but how i can download these add-in
    pls help me
    my mail id is bparesh_123@yahoo.com

    ReplyDelete
  23. Anonymous6:55 PM

    Hi, I still havent reced the file over email. Could you please email the same to bhandarigaurav@gmail.com

    ReplyDelete
  24. Anonymous11:21 AM

    Hi premal,

    I still havent received the attached file. could u pls help me to have add in file.

    my email id is anbu_c74@rediffmail.com

    pls help me

    ReplyDelete
  25. hi premal,

    i appreciate your efforts,
    i hanenot found any attachment here,
    kindly mail me at pallavikukil@yahoo.com
    thanx
    kukil kumar agarwal FCA
    lucknow

    ReplyDelete
  26. hi premal

    i did not find any attachment

    kindly mail me at pallavikukil@yahoo.com

    ReplyDelete
  27. i have not received any attachment

    kindly mail me at pallavikukil@yahoo.com

    ReplyDelete
  28. Anonymous12:08 PM

    Hi Premal,

    Pls. send me the AmtInWords.xla attachment to convert amt. in figures to words.
    My mail ID is: vibhu.vidyarthi@rediffmail.com

    Thanks & Regards,
    Vibhu

    ReplyDelete
  29. Anonymous9:41 AM

    Pls. send me the AmtInWords.xla attachment to convert amt. in figures to words.I could not find the attachment
    My e-mail ID is: snco2005@yahoo.co.in
    & snco@vsnl.net

    Warm regards,

    Shyam

    ReplyDelete
  30. Anonymous11:30 AM

    hi iam sachin plz, can you mail the attachment to this address
    ssparnatti@gmail.com

    ReplyDelete
  31. Anonymous2:27 PM

    Pls. send me the AmtInWords.xla attachment to convert amt. in figures to words.I could not find the attachment
    My e-mail ID is: manojnayak@india.com
    & manoj.nayak@steveandbarrys.com

    Warm regards,

    Manoj Nayak

    ReplyDelete
  32. Anonymous3:38 PM

    kindly forward the attchment-amtinwords.xla to ssunil@amadeus.co.in

    ReplyDelete
  33. Anonymous2:06 PM

    no files is attached anywhere ...

    ReplyDelete
  34. Anonymous3:33 PM

    Hi Ashwin,

    I was looking for some addins which can convert numbers to words. Good that you have done it.

    I couldn't find the addin anywhere, so it would be great if you could kindly forward it to my id: dutta.arjun@gmail.com

    Thanks,
    Arjun

    ReplyDelete
  35. Anonymous1:00 PM

    NSU - 4efer, 5210 - rulez

    ReplyDelete
  36. Anonymous4:09 PM

    Can u pls send me the file to convert figures to Indian Rupees to gthannickal@gmail.com. Thanks in advance.

    ReplyDelete
  37. bgurumoorthy@bsnl.in4:52 PM

    good work ,,

    pl. send the file to my email

    bgurumoorthy@bsnl.in

    ReplyDelete
  38. I could'nt locate the add-in AmtInWords.xla. Will be thankful if you may kindly email to rohitmgupta@gmail.com

    Thanks
    Rohit

    ReplyDelete
  39. Hi
    I am Swaraj Bose.
    I am interested in your Excel Add-in to convert amount in figures to words
    but but I didn't find the attached file. Plesae send the same at your earliest. (I was wondering how some of them got it).
    my mail id is swarajkbose@yahoo.com
    Thanks & regards.
    Swaraj

    ReplyDelete
  40. could you please mail me the amount in words.xla at my id :
    jbl_data@yahoo.com

    ReplyDelete
  41. Anonymous7:40 PM

    Kindly post me the amount in words.xla at my id :
    bijaya_ku_panda@sify.com

    ReplyDelete
  42. Anonymous1:57 PM

    Hi Suresh

    A very good job done. It is really very useful. Will you please do it in hindi also like रुपये तीन करोड़ तीस लाख तेंतीस हज़ार पांच सौ सत्ताईस और पैसे इक्सठ मात्र (33033527.61)? I want to try it after getting editable version of your code but I do not know how to type Hindi(unicode)in Visual Basic.

    Regards

    A K Trehan
    aktrehan@rbi.org.in

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
  43. Your utility appears to be very useful looking at the comments posted by other people , but i have not got any code or attached file.can u pls mail me that file at my email id:

    raja.bnglr@gmail.com


    Raja Gupta
    Delhi

    ReplyDelete
  44. Anonymous12:53 PM

    Hi, Mr. Ashwin,

    Can you please mail me the excel add-ins "Amtinwords.xla"

    Thanks
    Pradeep.
    my email id: pd.2002@rediffmail.com

    ReplyDelete
  45. Anonymous7:16 PM

    Hello Ashwini ji,
    Could you please send me the amountinwords.xls to email id sushiljalan@gmail.com
    Thanks

    ReplyDelete
  46. Anonymous8:26 PM

    In case you need to convert amount in words as per Indian number system (using Lakh, Crore) and formatting cells as per Indian Decimal System (e.g. 1234567.00 to 12,34,567.00) you can download one free addins "Indian Rupees" from below site.

    http://in.geocities.com/shahshaileshs/

    Or download one workbook "indianspellnoformula" (scroll to 5) from below webpage, which has formula to convert numbers to words as per Indian System.

    No VBA codes required.

    http://in.geocities.com/shahshaileshs/misc.htm



    And wishing you all a Happy New Year - 2008.


    With Regards,
    Shailesh Shah
    http://in.geocities.com/shahshaileshs/

    ReplyDelete
  47. Anonymous2:37 PM

    please email me also "AmtInWords.xla" kindly ... clever_mehru@hotmail.com

    Thanks

    ReplyDelete
  48. Anonymous12:55 PM

    I have come to know about y'r Amtinwords but i have not received the VB code file so please send it on bkkiran108@yahoo.com

    ReplyDelete
  49. Hi Ashwin,

    If you can please send me the amount in word add-in. Thanks in advance.
    My email address is tarun.gunja@tarunkgunja.com

    ReplyDelete
  50. Dear Sir,

    This is a very good tool for amateurs like us who work on excel. Please send me the attached file. Thanking you in advance. My email is mananth@hotmail.com

    ReplyDelete
  51. Anonymous4:53 PM

    i too have not received convert of numbers into words pls send my chirukurivenkat@gmail.com

    ReplyDelete
  52. Hi Premal

    If you can please send me a copy of this....

    Regards,
    Tarun

    ReplyDelete
  53. Anonymous7:21 PM

    hi ashwin h r u if u have this file please send this to me i am really thankful to you

    ReplyDelete
  54. dear sir,

    please send your amtinwords xl addin for inr to my maild krishnans77@rediffmail.com

    ReplyDelete
  55. Anonymous8:12 AM

    please send me also your AmtInWords.xla add-in

    nicgonzalo@yahoo.com

    Thanks for creating this wonderful work.

    ReplyDelete
  56. Anonymous1:15 PM

    Hi
    I am Mukesh Jain.
    I am interested in your Excel Add-in to convert amount in figures to words
    but but I didn't find the attached file. Plesae send the same at your earliest. (I was wondering how some of them got it).
    my mail id is mukesh4jain@yahoo.com
    Thanks & regards.

    ReplyDelete
  57. Anonymous2:30 PM

    Hi
    I am Basant Todi.
    I am interested in your Excel Add-in to convert amount in figures to words
    but but I didn't find the attached file. Plesae send the same at your earliest. (I was wondering how some of them got it).
    my mail id is todibasant@hotmail.com
    Thanks & regards.

    ReplyDelete
  58. Anonymous2:53 PM

    Hi,

    Can u plz. send me the attachment to convert amount in words.

    my email id k_vadde@yahoo.com

    Thanks,
    Kavita

    ReplyDelete
  59. Hi,

    I am sanjay yadav im too interesed in you add ins, i dont find any attachment here, i can see some codes written, does it work copy the code and pasting it in a new module if not please send a copy of addins "AmtInWords.xla" to my email id. sanjay.yadav.s@gmail.com

    thank you

    Sanjay

    ReplyDelete
  60. Hi Guys,


    Could't see the link to download the Add-in however, I got something similer for INR...

    http://ritwik-shukla-vb.blogspot.com/

    Try it out and let me know... it takes values upto


    99999999999(Ninety Nine Arab Ninety Nine Crore Ninety Nine Lac Ninety Nine Thousand Nine Hundred Ninety Nine Rupees)

    and also the second digit of decimal... The codes are not locked...

    ReplyDelete
  61. Anonymous7:57 AM

    I have email you one excel com-addins that convert amount in Hindi words.
    e.g 12,345.60 to
    रुपये बारह हज़ार तीनसौ पैंतालीस और पैसै साठ मात्र
    Regards,
    Shailesh
    -----------------------------------


    Hi Suresh

    A very good job done. It is really very useful. Will you please do it in hindi also like रुपये तीन करोड़ तीस लाख तेंतीस हज़ार पांच सौ सत्ताईस और पैसे इक्सठ मात्र (33033527.61)? I want to try it after getting editable version of your code but I do not know how to type Hindi(unicode)in Visual Basic.

    Regards

    A K Trehan
    aktrehan@rbi.org.in

    ReplyDelete
  62. Anonymous2:18 PM

    Hi,

    Thanks to Premal Mehta for your efforts. But, i did not find any attachment, please send "AmtInWords.xla" to indar67@gmail.com.

    Regards
    Ravindra

    ReplyDelete
  63. Anonymous7:07 PM

    Mr.Premal Mehta

    Please send me amtinwords.xla at n_mangwani"hotmail.com or mangwani"espic.in

    thanks
    C.A.Narendra Mangwani

    ReplyDelete
  64. karthik1:29 PM

    I was not able to find the link for ur file.

    KIndly forward the same to my email = kraj17@rediffmail.com

    Thank u so much
    Karthik

    ReplyDelete
  65. Anonymous9:50 PM

    hi pls mail to
    parimi.sateesh@gmail.com

    ReplyDelete
  66. Anonymous12:59 PM

    Please email the AmtInWords.xla file to my email id: shankaraveeramani@yahoo.com
    Thanks

    ReplyDelete
  67. Anonymous6:26 PM

    Not able to find attachments.....

    sanjeev

    ReplyDelete
  68. CA RAVI KUMAR AGRAWAL12:25 PM

    I can't find the attached file Please send it to my id
    ats.ca.rgh@gmail.com

    ReplyDelete
  69. Anonymous8:32 PM

    Please email the add-in to SureshNawras@yahoo.co.uk

    ReplyDelete
  70. I could not see any attachment pl. forward the same to my mail Id nandalala@lexisindia.com

    ReplyDelete
  71. Anonymous2:48 PM

    Kindly send this add-on (AmtInWords.xla)with syntex at dhakar4u@gmail.com

    ReplyDelete
  72. Anonymous12:37 AM

    Hi, i could see the attachment. Kindly send the email to shmogli123@gmail.com

    ReplyDelete
  73. Anonymous3:28 PM

    HI Ashwin,
    can you please send me the addin to dw0400@gmail.com
    you're doing a great job, keep it up!!!!
    cheers!!!

    ReplyDelete
  74. Anonymous4:18 PM

    Please send the file to me. Thanks
    Minto
    Minto86@gmail.com

    ReplyDelete
  75. Anonymous1:57 PM

    I could not see any attachment; please forward the same to my mail Id nibedita.chowdhury@digitalavenues.com

    Regards,
    Nibedita

    ReplyDelete
  76. I can't find the attached file Please send it to my id
    krtexsurat@gmail.com - Thanks in advance

    ReplyDelete
  77. Please mail me amount to word in hindi xla or xll or dll
    at rkndroid@gmail.com

    Regards

    RKNDROID

    ReplyDelete
  78. i could not find any attachment. pls mail the same (convert : figures to words) at my id : givo.pradeep@gmail.com

    ReplyDelete
  79. Anonymous12:09 PM

    Hi ,
    for anyone who do not have the attachment,please go to the following link
    http://www.citehr.com/212168-covert-amount-figures-word-ms-excel.html
    i found it there.
    hope it help..

    ReplyDelete
  80. Anonymous12:13 PM

    Hi, I could not find the attachement. Could you please send the same on s.dave@efkonindia.com

    ReplyDelete
  81. Thanks for your interesting article www.eradominoqq.com
    domino99

    ReplyDelete

  82. Playing poker it is a pleasure to waste time and relieve stress on the head go visit my website
    Domino99
    Domino qq
    Poker online

    Thank you for allow me to comment in here, YOUR ARITKEL IS VERY NICE



    ReplyDelete
  83. Thank you for allow me to comment in here, YOUR ARITKEL IS VERY NICE

    Poker Online
    Situs Poker
    Dominoqq
    Domino99
    Bandarq
    kiu kiu
    qiu qiu

    ReplyDelete

Post a Comment

What do you think about this? Please write your comment.

Popular posts from this blog

INSPECTION MANUAL OF STOCK, BOOK DEBTS & SECURITIES

CONTENTS SR. NO. CHAPTER PAGE NO. INTRODUCTION STOCK & RECEIVABLES AUDIT VERIFICATION OF STOCK & DEBTORS PROCEDURE OF STOCK AUDIT VERIFICATION OF SECURITIES ANALYTICAL REVIEW INTERNAL CONTROL QUESTIONNAIRE STOCK b) BOOK DEBTS LIST OF DOCUMENTS TAKEN AS WORKING PAPERS SPECIMEN INSPECTION REPORT SPECIMEN MANAGEMENT REPRESENTATION LETTER CHAPTER 1 INTRODUCTION: Banking is an important sector of the economy of any country and for the development of the economy a healthy banking system is a must. After the liberalization of the economy, the banking system has undergone a total change in India. There is hard competition in the banking industry to survive in the current circumstances. With the purpose to have better financial discipline & to ensure uniformity in accounting norms RBI introduced the concept of assetclassification & income recognition as per the recommendations of Narasimhan Committee. It was also suggested to classify the advances given by banks into Performing & Non Perfor…

Pradhan Mantri Garib Kalyan Deposit Scheme (PMGKDS), 2016?

*1. What is Pradhan Mantri Garib Kalyan Deposit Scheme (PMGKDS), 2016?*Pradhan Mantri Garib Kalyan Deposit Scheme (PMGKDS), 2016 is a scheme notified by the Government of India on December 16, 2016 which is applicable to every declarant under the Taxation and Investment Regime for Pradhan Mantri Garib Kalyan Yojana, 2016.*2. Who is eligible to deposit in PMGKS?*The deposit under this Scheme shall be made by any person who declared undisclosed income under sub-section (1) of section 199C of the Taxation and Investment Regime for Pradhan Mantri Garib Kalyan Yojana, 2016.*3. In what form will the deposits under this scheme be held?*The Deposits shall be held at the credit of the declarant in Bond Ledger Accounts (BLA) maintained with Reserve Bank of India.*4. Who are the authorized agencies where the application and amount of deposit will be accepted?*Application and amount for the deposit (in the form of Bond Ledger Account) shall be received by any banking company to which the Banking …