Convert number into word in excel in Indian Rupees,, this code will work in all version of Microsoft Excel like (2003, 2007, 2010, 2013). Just fallow these easy steps.
1) Copy this code
Function SpellNumber(amt As Variant) As Variant Dim FIGURE As Variant Dim LENFIG As Integer Dim i As Integer Dim WORDs(19) As String Dim tens(9) As String WORDs(1) = "One" WORDs(2) = "Two" WORDs(3) = "Three" WORDs(4) = "Four" WORDs(5) = "Five" WORDs(6) = "Six" WORDs(7) = "Seven" WORDs(8) = "Eight" WORDs(9) = "Nine" WORDs(10) = "Ten" WORDs(11) = "Eleven" WORDs(12) = "Twelve" WORDs(13) = "Thirteen" WORDs(14) = "Fourteen" WORDs(15) = "Fifteen" WORDs(16) = "Sixteen" WORDs(17) = "Seventeen" WORDs(18) = "Eighteen" WORDs(19) = "Nineteen" tens(2) = "Twenty" tens(3) = "Thirty" tens(4) = "Fourty" tens(5) = "Fifty" tens(6) = "Sixty" tens(7) = "Seventy" tens(8) = "Eighty" tens(9) = "Ninety" FIGURE = amt FIGURE = Format(FIGURE, "FIXED") FIGLEN = Len(FIGURE) If FIGLEN < 12 Then FIGURE = Space(12 - FIGLEN) & FIGURE End If If Val(Left(FIGURE, 9)) > 1 Then SpellNumber = "Rupees " ElseIf Val(Left(FIGURE, 9)) = 1 Then SpellNumber = "Rupee " End If For i = 1 To 3 If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2))) ElseIf Val(Left(FIGURE, 2)) > 19 Then SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1))) SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1))) End If If i = 1 And Val(Left(FIGURE, 2)) > 0 Then SpellNumber = SpellNumber & " Crore " ElseIf i = 2 And Val(Left(FIGURE, 2)) > 0 Then SpellNumber = SpellNumber & " Lakh " ElseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then SpellNumber = SpellNumber & " Thousand " End If FIGURE = Mid(FIGURE, 3) Next i If Val(Left(FIGURE, 1)) > 0 Then SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 1))) + " Hundred " End If FIGURE = Mid(FIGURE, 2) If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2))) ElseIf Val(Left(FIGURE, 2)) > 19 Then SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1))) SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1))) End If FIGURE = Mid(FIGURE, 4) If Val(FIGURE) > 0 Then SpellNumber = SpellNumber & " Paise " If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2))) ElseIf Val(Left(FIGURE, 2)) > 19 Then SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1))) SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1))) End If End If FIGURE = amt FIGURE = Format(FIGURE, "FIXED") If Val(FIGURE) > 0 Then SpellNumber = SpellNumber & " Only " End If End Function
2) Open excel sheet and press “Alt+F11”
3) A new windows will appear click on “Inert” and then “Module”
4) Paste the code in box
5) Click on “File” and then “Close and return to Microsoft Excel”
6) Keep the course in box where you want to convert number to word and type “=spellnumber(row & column)” (Eg. E7) and press “Enter”
97 comments:
Very useful. Thanks for sharing the code.
Please let me know whether this will work in all excel file or a particular file?
Very useful. Thanks
It works on the particular excel file where we put the codes. Can you please tell me how to add this codes in all excel files!!
Very useful. Thanks
very useful thanks a million
Thank you ! Need this feature on your android phone ?
You have problems writing your amounts in letters on checks? transfer form? rebate check form?
SpellMyAmount facilitate you all this; you enter the amount in numbers and it writes it for you in letters.
SpellMyAmount is an Android application available on Google Play!
Download it now: https://goo.gl/55u2YQ
Thank You! Very Much.....!
Very Useful. Thanks for sharing
very very useful thanks for sharing this programme
thank you very much.............very helpful guideline
How to save excel file with this code, so if i open excel next day it will work
very nice brooooo
Lots of Thanks Bro
tq very much its very use full
How can we use for us dollars?
How can we use for us dollars?
Very useful. Thanks for sharing just like this code. Please share if we want to use it like this 1) Thousands, 2) hundred thousands, 3) millions, 4) trillions etc.
this formula works for same sheet means in which we had put formula
but in another file, it does not work.
pl. guide.
Thank you very much. This worked great ! God Bless you.
Thank You Very Much
Thanks for sharing
hat off man
thanking you a lot sir it useful us very much. great job sir
not working
it is very helpful for me. thanks a lot sir...why NinetyFive like this
VERY NICE AND HILLY USEFUL TO ME
BUT WHY IT CHANGE EVERY TIME WHEN OPEN
CAN DO PERMEATE SAVE
REGARDING MECRO
Thanks for the Program, its very useful!!
Great job dude!!
I'm facing different problems while opening the file 2nd time,
Error 1: Compile error: Syntax error (I can't understand about this type of error)
Error 2: #NAME? (On cell where I put formula previous)
Please help me to solve this problem.
Thanks for the info.
Will this work in OS X?
Dear Sir,
Can u pls tell me can i use spell number for Dollar & rupees at the same time???
Sir,
Thanks for the code
धन्यवाद मेरे भाई
तूने तो मेरी जिंदगी बदल दी
this formula works for same sheet means in which we had put formula
but in another file, it does not work.
pl. guide.
Can i use this permanently, each and everytime i have to paste this code in same file also.
kindly let me know permanent solution of this.
its working, thank you.
but here i want set rupees beside of words mean set in last so how can set it?
Thanks Sir You r Grate
Compile error
User - Defined type not defined
..... what to do
Compile error
User - Defined type not defined
..... what to do
Hi,
Thanks for heplp.
Please fix following bugs.
No space between tens.
Thanks
thanks a lot... helped me a lot.. thanks
thank you for your vb script
i want to know the how can i make full capital letter?
thanks
Hello every one, i just used this all steps but it's not working...please help
Copy this code in new workbook's module and save it
Save excel file with extension
.xla (addin)
use that addin in excel addin, then it will available for all workbook
There is a problem when you want to see the "paise" it appears like (12.5)=Rupees twelve paise fifty only. Please fix this in your code and inform me.
Thanxz Alot Bro
Thanks
Great tutorial is useful and very necessary for me
THANKS ALOOT
Extremly superb. Explained very nicely. Thanks a lot.
very usefull thanx
excellent Tnx
very useful and thank you
Thank you so much sir. Its very useful. God Bless You
Thank you for sharing this helpful guide. I need such information
There is a error as "ambiguous name detected" when i put the formula please help..
Thank you bro you saved lot of time. thank you please share all which you have made. thankfull to you my best regards. Pramod.S India
excellent work keep doing
Really enjoyed this blog post, can I set it up so I get an update sent in an email when you write a fresh update? website for SEM
When I originally commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Many thanks! seo in singapore
A lead can be any individual consumer or contact within a company that completes an inquiry form, registers for an event, or some sort of similar action.
search engine optimisation
Greetings! I know this is kinda off topic however I'd figured I'd ask. Would you be interested in exchanging links or maybe guest authoring a blog post or vice-versa? My website addresses a lot of the same subjects as yours and I think we could greatly benefit from each other. If you are interested feel free to send me an e-mail. I look forward to hearing from you! Great blog by the way!
student hosting singapore
A health foods store, for example, might partner with a gym to put on a series of healthy living classes. You might also consider cold calling, networking, or affiliate marketing.
digital agencies based in Singapore
thank you for your guideline and sharing this code.
I'm not sure exactly why but this site is loading incredibly slow for me. Is anyone else having this issue or is it a issue on my end? I'll check back later and see if the problem still exists.
newsletters
When I said I was going to answer the first one first, it was because I can't answer the second one. Sorry.
Inbound Marketing by HubSpot Academy in Singapore
This is really an amazing blog. Your blog is really good and your article has always good thank you for information.
โปรโมชั่นGclub ของทางทีมงานตอนนี้แจกฟรีโบนัส 50%
เพียงแค่คุณสมัคร Gclub กับทางทีมงานของเราเพียงเท่านั้น
ร่วมมาเป็นส่วนหนึ่งกับเว็บไซต์คาสิโนออนไลน์ของเราได้เลยค่ะ
สมัครสล็อตออนไลน์ >>> goldenslot
สนใจร่วมลงทุนกับเรา สมัครเอเย่น Gclub คลิ๊กได้เลย
Excellent Post as always and you have a great post and i like it thank you for sharing
เว็บไซต์คาสิโนออนไลน์ที่ได้คุณภาพอับดับ 1 ของประเทศ
เป็นเว็บไซต์การพนันออนไลน์ที่มีคนมา สมัคร Gclub Royal1688
และยังมีหวยให้คุณได้เล่น สมัครหวยออนไลน์ ได้เลย
สมัครสมาชิกที่นี่ >>> Gclub Royal1688
ร่วมลงทุนสมัครเอเย่นคาสิโนกับทีมงานของเราได้เลย
Great..Thanks a lot..Very useful formula, simply explained.
how to leave space between tens and WORDs?
For Eg: Rs. 25879 it shows as Rupees TwentyFive Thousand Eight Hundred SeventyNine Only. I want spaces between Twenty Five and Seventy Nine.
Help?
ishop.global is providing Amazon products delivery services in Pakistan at very cheap rates we are same as Amazon Pakistan Now you can buy any product from Aliexpress ebay amazon and All other USA websites via ishop.global. https://ishop.global/
online shopping
online shopping in pakistan
amazon online shopping
amazon online shopping in pakistan
amazon pakistan
Global Shopaholics is a Package forwarding company based in Delaware USA. We are proud to offer the cheapest International shipping rates from the USA to anywhere in the world to your Doorstep. Global Shopaholics core value is based on excellent customer experience while shopping internationally. Our main goal is to make international shopping shipping experience smooth, economical and easy. For more information keep visiting our website: globalshopaholics.com
shop and ship
myus
viabox
this formula works for same sheet means in which we had put formula
but in another file, it does not work.
pl. guide.
Thank you very much for these tips! Hey, I am currently very stressed about writing my college essays lol and I have a quick question. I feel that my passion for science and learning is probably the most defining part of my character, BUT I don't want my essay to seem broad, cliche, or like I am just trying to impress the college! Do you think if I told the story about the time at a science museum when I realized how excited science made me that this topic would be specific enough? Btw I wrote a full essay this morning about how adopting a positive mindset has changed my life then trashed it bc I know that is too cliche hahaha helpppp. This was a very helpful article btw!! Find out more here: www.5staressays.com
At smartcityprestige Chauffeur Hire, our vehicles can be hired for any purpose - from airport transfers to prom-nights, special celebrations to wedding cars. We can even provide cars for photo shoots and promotional events. Whatever your requirement, we have the chauffeurs and cars to suit your budget: Get a Quite Visit our website: https://www.smartcityprestige.com/
we pride ourselves on delivering a fantastic personal chauffeur service to all our clients, whether it's wedding cars, luxury business travel or a special day out for the family.
airport chauffeur services
airport chauffeurs
London chauffeur companies
Wedding car hire london
Photo Background Editor plays a key role in removing the background of the photo. The editor needs to remain highly careful while removing the background. The service is an essential one for the online business community.
My brother suggested I might like this website. He was totally right. This post truly made my day. You cann't imagine simply how much time I had spent for this info! Thanks!
Make Your Website SEO-Friendly
Useful Information :
Looking for the Best Digital Marketing Company in Vijayawada and Hyderabad affiliate agency in south INDIA, Digital Marketing in Vijayawada @ praiseads.com
Great Article
Looking for the Best Walkin Interviews For Freshers , Find latest Govt Job Notifications with various information such as govt vacancies, eligibility, Bank Jobs, Latest Bank Job Updates @ pdtvjobs.com
We the BRS team which stands for Background Removal Services are providing you with highly graphic design and photo editing and obviously the most popular brand identity design at your cost. Do Visit to have the view of creative ideas of designs. Creative designs do help to grab the attraction of the customers. Make your own business flourish with powerful design concept today!
Useful Information :
Looking for the Best
Digital Marketing Company in Vijayawada and Hyderabad affiliate agency in south
INDIA, Digital Marketing in Vijayawada @ praiseads.com
ptcl bill online
duplicate bill ptcl
bill download ptcl
rootmaster apk
root master apkpure
lords mobile pc
We have team of mobile mechanics who can fix car maintenance, oil change, mot bracknell service, car repair service or can take the car to our approved garages and get it all sorted.
smartservicingcentre.co.uk
smart servicing centre Blog
Useful Information :
Freshers Walkins provide information on all the job walkins happen in all over India. Popular IT Company jobs, Freshers walkins, java walkins, .net walkins @ http://fresherswalkins.co.in/
intensive driving courses guaranteed pass
intensive driving course near me
https://intensivepass.co.uk/areas-we-cover
So very useful Your work is much appreciated. Thanks a lot for share.
Clipping path is a must for any kinds of product images. Clipping Path Service can provide you with your desired product with a high-end view which will help you to attract both the organic customers and paid to add customers. Do clipping path for your business growth and show your customers what you have!
Image Retouching is a standout amongst the most noteworthy administrations in Image altering. It expedites a positive vibe and look the Image. The majority of the end-level clients are in extraordinary necessities of image retouching Services. Be that as it may, you should be cautious while choosing the best one.Chat discussion end Type a message....
Useful Information :
Are you planning to Study Abroad? Visit Study Abroad Institute one of the most trusted study abroad consultants in India and let overseas education in UK, USA @ http://studyabroadinstitute.com/
Useful Information :
New Job Alert , New Job Alert Updates - Create New Job Alert notification alerts for bank jobs, government jobs, IT jobs, fresher new job alerts.
Nice Information
Freshers Walkins provide information on all the job walkins happen in all over India. Popular IT Company jobs, Freshers walkins, java walkins, .net walkins @ http://fresherswalkins.co.in/
Clipping path service is one kind of image editing Process where we select a important portion of an image and cut the unimportant part Clipping path We can delete the background or change background color to make it more attractive.
Useful Information :
Are you planning to Study Abroad? Visit Study Abroad Institute one of the most trusted study abroad consultants in India and let overseas education in UK, USA @ http://studyabroadinstitute.com/
Useful Information :
New Job Alert , New Job Alert Updates - Create New Job Alert notification alerts for bank jobs, government jobs, IT jobs, fresher new job alerts.
Post a Comment