Tuesday, 10 June 2014

How to Convert Number into Word in Excel in Indian Rupees

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”

See Video tutorial..... Please like, share and subscribe 

84 comments:

KD SINGH said...

Very useful. Thanks for sharing the code.

KD SINGH said...

Please let me know whether this will work in all excel file or a particular file?

Jayant Volvoikar said...

Very useful. Thanks

Ashish Soni said...

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!!

pallabjyoti kalita said...

Very useful. Thanks

Darshana Mrug said...

very useful thanks a million

Maher Sakka said...

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

Manoj Kajale said...

Thank You! Very Much.....!

vijay kumar karma said...

Very Useful. Thanks for sharing

Krunal Gilitwala said...

very very useful thanks for sharing this programme

Khairul Hasan said...

thank you very much.............very helpful guideline

Samarth Gupta said...

How to save excel file with this code, so if i open excel next day it will work

murali Perike said...

very nice brooooo

Unknown said...

Lots of Thanks Bro

Unknown said...

tq very much its very use full

Yam Sophanna said...

How can we use for us dollars?

Yam Sophanna said...

How can we use for us dollars?

ukjobs said...

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.

Anonymous said...

this formula works for same sheet means in which we had put formula
but in another file, it does not work.
pl. guide.

I am That said...

Thank you very much. This worked great ! God Bless you.

Anonymous said...

Thank You Very Much

Unknown said...

Thanks for sharing

Sufi Alam said...

hat off man

Goli krishna chaitanya said...

thanking you a lot sir it useful us very much. great job sir

Subhash Garg said...

not working

Md Aminul Islam Nirob said...

it is very helpful for me. thanks a lot sir...why NinetyFive like this


Jagesh Ladani said...

VERY NICE AND HILLY USEFUL TO ME
BUT WHY IT CHANGE EVERY TIME WHEN OPEN
CAN DO PERMEATE SAVE
REGARDING MECRO

suri said...

Thanks for the Program, its very useful!!
Great job dude!!

Anonymous said...

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.

Anonymous said...

Thanks for the info.

Kketan Chheda said...

Will this work in OS X?

Praviin Pollhke said...

Dear Sir,

Can u pls tell me can i use spell number for Dollar & rupees at the same time???

pankaj kachari said...

Sir,

Thanks for the code

Anonymous said...

धन्यवाद मेरे भाई
तूने तो मेरी जिंदगी बदल दी

Pramukh Packers said...

this formula works for same sheet means in which we had put formula
but in another file, it does not work.
pl. guide.

ravindar said...

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.

Umesh said...

its working, thank you.
but here i want set rupees beside of words mean set in last so how can set it?

Raju Mondal said...

Thanks Sir You r Grate

Akash Nikam said...

Compile error
User - Defined type not defined
..... what to do

Akash Nikam said...

Compile error
User - Defined type not defined
..... what to do

Anonymous said...

Hi,
Thanks for heplp.

Please fix following bugs.

No space between tens.

Thanks

girish joshi said...

thanks a lot... helped me a lot.. thanks

hasan said...

thank you for your vb script

i want to know the how can i make full capital letter?

thanks

Ayub Shaikh said...

Hello every one, i just used this all steps but it's not working...please help

Anonymous said...

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

Syed Mahadi said...
This comment has been removed by the author.
Syed Mahadi said...

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.

Anonymous said...

Thanxz Alot Bro

Unknown said...

Thanks

vex 3 said...

Great tutorial is useful and very necessary for me

Ahamed Kizhissery said...

THANKS ALOOT

Unknown said...

Extremly superb. Explained very nicely. Thanks a lot.

Jai said...

very usefull thanx

Unknown said...

excellent Tnx

Unknown said...

very useful and thank you

Unknown said...

Thank you so much sir. Its very useful. God Bless You

vex 3 said...

Thank you for sharing this helpful guide. I need such information

Unknown said...

There is a error as "ambiguous name detected" when i put the formula please help..

Unknown said...

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

Unknown said...

excellent work keep doing

andrewmathew said...

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

kristinahojholt said...

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

soanferry said...

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

kristinahojholt said...

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

joggycaf said...

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

Jiban said...

thank you for your guideline and sharing this code.

kristinahojholt said...

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

goneygark said...

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

Madoo said...

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 คลิ๊กได้เลย

Yakru45 said...

Excellent Post as always and you have a great post and i like it thank you for sharing

เว็บไซต์คาสิโนออนไลน์ที่ได้คุณภาพอับดับ 1 ของประเทศ
เป็นเว็บไซต์การพนันออนไลน์ที่มีคนมา สมัคร Gclub Royal1688
และยังมีหวยให้คุณได้เล่น สมัครหวยออนไลน์ ได้เลย
สมัครสมาชิกที่นี่ >>> Gclub Royal1688
ร่วมลงทุนสมัครเอเย่นคาสิโนกับทีมงานของเราได้เลย

Anonymous said...

Great..Thanks a lot..Very useful formula, simply explained.

Unknown said...

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?

sammatkhan said...

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

hollywoodmovies said...

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

Unknown said...

this formula works for same sheet means in which we had put formula
but in another file, it does not work.
pl. guide.

staf join said...

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

join ray said...

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/

Tahir Saleem said...

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 said...

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.

andrewmathew said...

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

Digital Marketing Company in Vijayawada said...

Useful Information :

Looking for the Best Digital Marketing Company in Vijayawada and Hyderabad affiliate agency in south INDIA, Digital Marketing in Vijayawada @ praiseads.com

Walkin Interview For Freshers said...

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

Photo Editing Service said...

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!

Digital Marketing Company in Vijayawada said...

Useful Information :

Looking for the Best
Digital Marketing Company in Vijayawada
and Hyderabad affiliate agency in south
INDIA, Digital Marketing in Vijayawada @ praiseads.com

Popular Posts