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

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?

Unknown said...

Very useful. Thanks

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

Unknown said...

Very useful. Thanks

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

Unknown said...

Thank You! Very Much.....!

vijay kumar karma said...

Very Useful. Thanks for sharing

Unknown said...

very very useful thanks for sharing this programme

Unknown said...

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

Unknown said...

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

Unknown said...

very nice brooooo

Unknown said...

Lots of Thanks Bro

Unknown said...

tq very much its very use full

Unknown said...

How can we use for us dollars?

Unknown 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

Unknown said...

hat off man

Unknown said...

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

Unknown said...

not working

Md Aminul Islam Nirob said...

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

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 2: #NAME? (On cell where I put formula previous)

Anonymous said...

Thanks for the info.

Unknown said...

Will this work in OS X?

Unknown said...

Dear Sir,

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

Unknown said...

Sir,

Thanks for the code

Anonymous said...

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

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.

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?

Unknown said...

Thanks Sir You r Grate

Unknown said...

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

Unknown said...

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

Anonymous said...

Hi,
Thanks for heplp.

No space between tens.

Thanks

Unknown 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

Unknown said...

Anonymous said...

Copy this code in new workbook's module and save it
Save excel file with extension
use that addin in excel addin, then it will available for all workbook

Unknown said...
This comment has been removed by the author.
Unknown 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...

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.

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

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?

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

Digital Marketing Company in Vijayawada said...

Useful Information :

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
and Hyderabad affiliate agency in south

Zee said...
Zee said...

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

Freshers Walkins said...

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/

Zee said...
Clipping path service said...

So very useful Your work is much appreciated. Thanks a lot for share.

Clipping Path Service said...

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

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 :

Freshers Walkins said...

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

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 :

Walkin Interview For Freshers said...

Great Article

Looking for the Best Walkin Interview For Freshers , Find latest Govt Job Notifications with various information such as govt vacancies, eligibility, Bank Jobs, Latest Bank Job Updates @ pdtvjobs.com

رواد الحرمين said...

شركه كشف تسربات المياه بالاحساء

شركه تنظيف منازل بالجبيل
والصدق والامانه فى العمل ، وهدفنا هو ارضاؤك وراحتك ، لا تقلق ونحن معك

شركه عزل فوم بالجبيل
لا تجهد نفسك ونحن تحت امرك ورهن اشارتك .
أبرز خدمات مؤسسة الحرمــين للمقاولات العامة بالدمام والرياض

شركه عزل فوم بالدمام

Blog comment said...

Hello Dear sir, Blog comment pending & apporve step by step comment publish. please click and beautiful my gig. I'll do it the same for you. Thank you for sharing.
Blog Comment