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
Subscribe to:
Post Comments (Atom)
-
Drafts of tax accounting standard on construction contracts, government grants issued The Central Board of Direct Taxes (CBDT) has invited c...
-
After the ICAI regional council and central council elections , there is an anxious waiting period for resul...
-
Here is the final list of candidates won from WIRC for Central Council: Sr. No. Name of Candidate 1 CA. Adukia Rajkumar Satyanarayan 2 CA...
Good Work Premal
ReplyDeleteMillion thanks to Premal Mehta. I have tried and tested, it is a wonderful add-in.
ReplyDeleteBharat Desai - CA.
I not seen any attached file with this post. Please send me the attached file.
ReplyDeleteGopal Garg
I have not received any attached file with mail. You are requested to attechment again to help me.
ReplyDeleteHinabshu V. Shah
Hi Ashwin !! i wasn't able to see the file. can u pls e mail the same.
ReplyDeleteregards
Saurabh
Gopal/Hinabshu/Saurabh:
ReplyDeleteIf 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
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
ReplyDeleteI too have not received the attachment. could you send me the same an oblige me on email address sandeepjsinghal@hotmail.com
ReplyDeleteSandeep
I too have not received any attachment if you send it on my ID
ReplyDeletedybhatt@rediffmail.com
I have not seen any attachment.Pl send in the following address:
ReplyDeletepjm@ambujamail.com
I have not seen any attachment. plz send in the following address :
ReplyDeletesushilarora30@yahoo.co.in
can you send me the attachment to at ravisankar30@gmail.com
ReplyDeletePlease send me this utility to nasluck@yahoo.com
ReplyDeleteplease e mail me on ID
ReplyDeletemadan.vaishnawa@gmail.com
kindly send it to me also at palshotelmumbai@yahoo.co.in
ReplyDeletethx alot Pals Hotel
kindly semd me the file.
ReplyDeletethanks
goenkapankaj@yahoo.com
Please send Amtinwords.xla file to the email id : dayanand27@rediffmail.com
ReplyDeleteCould you please email the file to bhandarigaurav@gmail.com.
ReplyDeleteThanks
pls send the attachment to vikasagarwal77@yahoo.co.in
ReplyDeletePlease send the attachmment to adibedekar@yahoo.com
ReplyDeleteHi
ReplyDeleteI 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
Hi, I still havent reced the file over email. Could you please email the same to bhandarigaurav@gmail.com
ReplyDeleteHi premal,
ReplyDeleteI 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
Hi Premal,
ReplyDeletePls. send me the AmtInWords.xla attachment to convert amt. in figures to words.
My mail ID is: vibhu.vidyarthi@rediffmail.com
Thanks & Regards,
Vibhu
Pls. send me the AmtInWords.xla attachment to convert amt. in figures to words.I could not find the attachment
ReplyDeleteMy e-mail ID is: snco2005@yahoo.co.in
& snco@vsnl.net
Warm regards,
Shyam
hi iam sachin plz, can you mail the attachment to this address
ReplyDeletessparnatti@gmail.com
Pls. send me the AmtInWords.xla attachment to convert amt. in figures to words.I could not find the attachment
ReplyDeleteMy e-mail ID is: manojnayak@india.com
& manoj.nayak@steveandbarrys.com
Warm regards,
Manoj Nayak
kindly forward the attchment-amtinwords.xla to ssunil@amadeus.co.in
ReplyDeleteno files is attached anywhere ...
ReplyDeleteHi Ashwin,
ReplyDeleteI 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
Can u pls send me the file to convert figures to Indian Rupees to gthannickal@gmail.com. Thanks in advance.
ReplyDeletegood work ,,
ReplyDeletepl. send the file to my email
bgurumoorthy@bsnl.in
I could'nt locate the add-in AmtInWords.xla. Will be thankful if you may kindly email to rohitmgupta@gmail.com
ReplyDeleteThanks
Rohit
Hi
ReplyDeleteI 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
could you please mail me the amount in words.xla at my id :
ReplyDeletejbl_data@yahoo.com
Kindly post me the amount in words.xla at my id :
ReplyDeletebijaya_ku_panda@sify.com
Hi Suresh
ReplyDeleteA 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
This comment has been removed by the author.
DeleteYour 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:
ReplyDeleteraja.bnglr@gmail.com
Raja Gupta
Delhi
Hi, Mr. Ashwin,
ReplyDeleteCan you please mail me the excel add-ins "Amtinwords.xla"
Thanks
Pradeep.
my email id: pd.2002@rediffmail.com
Hello Ashwini ji,
ReplyDeleteCould you please send me the amountinwords.xls to email id sushiljalan@gmail.com
Thanks
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.
ReplyDeletehttp://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/
please email me also "AmtInWords.xla" kindly ... clever_mehru@hotmail.com
ReplyDeleteThanks
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
ReplyDeleteHi Ashwin,
ReplyDeleteIf you can please send me the amount in word add-in. Thanks in advance.
My email address is tarun.gunja@tarunkgunja.com
i too have not received convert of numbers into words pls send my chirukurivenkat@gmail.com
ReplyDeleteHi Premal
ReplyDeleteIf you can please send me a copy of this....
Regards,
Tarun
hi ashwin h r u if u have this file please send this to me i am really thankful to you
ReplyDeletedear sir,
ReplyDeleteplease send your amtinwords xl addin for inr to my maild krishnans77@rediffmail.com
please send me also your AmtInWords.xla add-in
ReplyDeletenicgonzalo@yahoo.com
Thanks for creating this wonderful work.
Hi
ReplyDeleteI 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.
Hi
ReplyDeleteI 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.
Hi,
ReplyDeleteCan u plz. send me the attachment to convert amount in words.
my email id k_vadde@yahoo.com
Thanks,
Kavita
Hi,
ReplyDeleteI 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
Hi Guys,
ReplyDeleteCould'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...
I have email you one excel com-addins that convert amount in Hindi words.
ReplyDeletee.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
Hi,
ReplyDeleteThanks to Premal Mehta for your efforts. But, i did not find any attachment, please send "AmtInWords.xla" to indar67@gmail.com.
Regards
Ravindra
Mr.Premal Mehta
ReplyDeletePlease send me amtinwords.xla at n_mangwani"hotmail.com or mangwani"espic.in
thanks
C.A.Narendra Mangwani
I was not able to find the link for ur file.
ReplyDeleteKIndly forward the same to my email = kraj17@rediffmail.com
Thank u so much
Karthik
hi pls mail to
ReplyDeleteparimi.sateesh@gmail.com
Please email the AmtInWords.xla file to my email id: shankaraveeramani@yahoo.com
ReplyDeleteThanks
Not able to find attachments.....
ReplyDeletesanjeev
I can't find the attached file Please send it to my id
ReplyDeleteats.ca.rgh@gmail.com
Please email the add-in to SureshNawras@yahoo.co.uk
ReplyDeleteI could not see any attachment pl. forward the same to my mail Id nandalala@lexisindia.com
ReplyDeleteKindly send this add-on (AmtInWords.xla)with syntex at dhakar4u@gmail.com
ReplyDeleteHi, i could see the attachment. Kindly send the email to shmogli123@gmail.com
ReplyDeleteHI Ashwin,
ReplyDeletecan you please send me the addin to dw0400@gmail.com
you're doing a great job, keep it up!!!!
cheers!!!
Please send the file to me. Thanks
ReplyDeleteMinto
Minto86@gmail.com
I could not see any attachment; please forward the same to my mail Id nibedita.chowdhury@digitalavenues.com
ReplyDeleteRegards,
Nibedita
I can't find the attached file Please send it to my id
ReplyDeletekrtexsurat@gmail.com - Thanks in advance
Please mail me amount to word in hindi xla or xll or dll
ReplyDeleteat rkndroid@gmail.com
Regards
RKNDROID
i could not find any attachment. pls mail the same (convert : figures to words) at my id : givo.pradeep@gmail.com
ReplyDeleteHi ,
ReplyDeletefor 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..
Hi, I could not find the attachement. Could you please send the same on s.dave@efkonindia.com
ReplyDelete