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
12 September 2005
Subscribe to:
Post Comments (Atom)
65 comments:
Good Work Premal
Indeed very useful formula.
Indeed very useful formula.
Million thanks to Premal Mehta. I have tried and tested, it is a wonderful add-in.
Bharat Desai - CA.
I not seen any attached file with this post. Please send me the attached file.
Gopal Garg
I have not received any attached file with mail. You are requested to attechment again to help me.
Hinabshu V. Shah
Hi Ashwin !! i wasn't able to see the file. can u pls e mail the same.
regards
Saurabh
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
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
I too have not received the attachment. could you send me the same an oblige me on email address sandeepjsinghal@hotmail.com
Sandeep
I too have not received any attachment if you send it on my ID
dybhatt@rediffmail.com
I have not seen any attachment.Pl send in the following address:
pjm@ambujamail.com
I have not seen any attachment. plz send in the following address :
sushilarora30@yahoo.co.in
can you send me the attachment to at ravisankar30@gmail.com
Please send me this utility to nasluck@yahoo.com
please e mail me on ID
madan.vaishnawa@gmail.com
kindly send it to me also at palshotelmumbai@yahoo.co.in
thx alot Pals Hotel
kindly semd me the file.
thanks
goenkapankaj@yahoo.com
Please send Amtinwords.xla file to the email id : dayanand27@rediffmail.com
Could you please email the file to bhandarigaurav@gmail.com.
Thanks
pls send the attachment to vikasagarwal77@yahoo.co.in
Please send the attachmment to adibedekar@yahoo.com
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
Hi, I still havent reced the file over email. Could you please email the same to bhandarigaurav@gmail.com
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
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
hi premal
i did not find any attachment
kindly mail me at pallavikukil@yahoo.com
i have not received any attachment
kindly mail me at pallavikukil@yahoo.com
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
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
hi iam sachin plz, can you mail the attachment to this address
ssparnatti@gmail.com
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
kindly forward the attchment-amtinwords.xla to ssunil@amadeus.co.in
no files is attached anywhere ...
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
NSU - 4efer, 5210 - rulez
Can u pls send me the file to convert figures to Indian Rupees to gthannickal@gmail.com. Thanks in advance.
good work ,,
pl. 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
Thanks
Rohit
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
could you please mail me the amount in words.xla at my id :
jbl_data@yahoo.com
Kindly post me the amount in words.xla at my id :
bijaya_ku_panda@sify.com
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
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
Hi, Mr. Ashwin,
Can you please mail me the excel add-ins "Amtinwords.xla"
Thanks
Pradeep.
my email id: pd.2002@rediffmail.com
Hello Ashwini ji,
Could 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.
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/
please email me also "AmtInWords.xla" kindly ... clever_mehru@hotmail.com
Thanks
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
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
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
i too have not received convert of numbers into words pls send my chirukurivenkat@gmail.com
Hi Premal
If 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
dear sir,
please send your amtinwords xl addin for inr to my maild krishnans77@rediffmail.com
please send me also your AmtInWords.xla add-in
nicgonzalo@yahoo.com
Thanks for creating this wonderful work.
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.
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.
Hi,
Can u plz. send me the attachment to convert amount in words.
my email id k_vadde@yahoo.com
Thanks,
Kavita
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
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...
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
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
Mr.Premal Mehta
Please 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.
KIndly forward the same to my email = kraj17@rediffmail.com
Thank u so much
Karthik
Post a Comment