Change the number to Word in Excel with this formula

[@akashzagade3487]

Bhaiiiiii........Awesome........Thanks a lot....

[@amritapotdar5518]

After watching so many videos this was very useful and easy for a non-expert Excel user like me. Thanks a lot for the Video.

[@sk.rahatilraihan33]

Thanks for sharing your creation. Keep sharing new creations.

[@nayanparmar9127]

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

[@ansariarbaz3263]

Copy kaise kre

[@harshasai-sivakumar6575]

Wonderful ❤❤❤❤❤❤❤ super thank you sooo much

[@Arushi1501]

Sir apne bhut achhe se formula bnaya h ek bar m hi work kr gya thank you so much other video m se maine formula try kiya tha toh error aa rha tha bar bar par apka video dekhkr formula lgaya ek bar m hi work kiya thank you Sir

[@mayankshukla5450]

Hello bhavna plz send me formula copy & past

[@sibtainmushtaq4387]

AOA sir g coding ko kistrah search krna hy

[@sibtainmushtaq4387]

Koi bta dain net say kia likhon

[@sibtainmushtaq4387]

Sir g bta dain please ap

[@tirloksingh5772]

Isse achcha to aap wo file hi download kr lete..

[@TheSinghBroadcast]

Great Boss 👍👍

[@vipinbajaj3213]

Beautifully explained with complete file. Thx a ton's from my side

[@fawadabbasi-r4v]

very good lecture 100% effective i did it...................................thanks Dear

[@krishnapatil5296]

Formula save karne ke bad sub execl sheet me work ho jayega kya,
Ki har naye sheet mein fir se process karna padega.

[@ZalasEducationZone]

No ho jaega fir save kar le us bill se new bill ko save as karna

[@mohankirti]

Superb.. worked as shown.. thanks

[@varunagarwal8848]

It was so well explained step by step and I was absolutely able to do it all comfortably without a single doubt.
Bas aapse ek request hai.
I couldn’t capitalise all the alphabets as main invoicing mein Har alphabet capital karta hoon.
Much appreciated 🙏🏻

[@travelltime9879]

Could u share a coding file with me

[@ihsanullah7974]

sir ye coding file kaha se key ge

[@carameshwaragarwal7438]

you may use =UPPER ( ) , =lOWER( ) formula.

[@azharpervaiz6268]

😅

[@nehatiwari4978]

sir coding file ka bina kase kara

[@Vinod_Surushe]

Kay bat hai Bhai , man Gaye 🥰🥰🤗

[@francisdsouza4206]

very well explained Sir. Thanks a lot for sharing your valuable information. the only thing is that there is no space coming 2 digit numbers. it's like this EightyFour. It should be like this Eighty Four. Anyway Thanks a Lot.

[@ashoksoumi]

In text file replace "One" with "one " and do the same for all the numbers mentioned.

[@skrasid7650]

@Ashok Soumi
It won't be done
@Francis Dsouza
Please mail me , I'll explain you 😊

[@shabrotherss]

Thank you boss. Superb tutorial.

[@takotari5352]

This formula works only that particular page only. Doesn't apply to other new open Excel sheet.

[@KanishkaRastogi-jc9ps]

Right

[@arunaaru3529]

Where he gt the things in notepad?how to take that

[@aashishjais]

​@@arunaaru3529go to the link in description

[@alimohdbilalraza]

Did you find anyway to do it in multiple/ other files

[@Rushikeshrajguru-qp7mn]

Formula

[@sukhmindersinghsidhu1502]

Very good information, it's really works

[@pritamsingh1012]

How to remove rupees
I have no need to write currency

[@QuickLearn2307]

Great Bhai, Huge Thanks.

[@lifesavingsocietyofindia808]

If you can kindly remove the "Rupees" and "only" from the coding and share us the link, it would be extremely helpful!

[@ashoksoumi]

Open text file and wherever "rupee","rupees","only" are there, replace them with ""
👍🏽

[@samarpitgupta3212]

Amount ke baad rupees lagate hai wo kaise add hoga is formule mai?

[@rassalrahman1245]

there you can change it use

[@SaurabhDiwedi-ut5fv]

wow,,,So usefull...!Thankyou so much for this useful info.

[@naseeruddinfaraz1433]

Love you Sir.❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

[@sakeforvous]

Super Bro, Ultimate. Thanks

[@vikassaini359]

Its Working thanks sir for very well explained

[@roychowdhurys1608]

Superb!! very easy to use. thank you

[@SAQIB-TOORI]

just lovely and helpful . loving

[@murthyrt7546]

thank you so much sir, i worked like a butter smooth, after this happened , i felt like a pro coder. wow love u sir. it took me almost 10 years to know this. i was using app called numbers to word n used to copy paste . thanks again sir,

[@theperfectimperfection3597]

Fantastically explained! Appreciated... Thank you.

[@grafiqeinterio1088]

Thank you, bro
God bless you

[@explore.kashmir26]

Thank you so much... It takes 2 minutes only... U deserve like and subscribe❤❤

[@InDuniLH]

wow thank you very much for this video.

[@DipankarMondal-fz6hv]

Thank you for sharing this information with us...🙏🏻🙏🏻🙏🏻

[@MOHAMMADIMRAN-k2i]

My dear brother, I very impressed with your first video, so I decided to subscribe your channel and press all bell icon. I hope you will help me more in future. May creator of universe make you better in your field.

[@binduuchiha8587]

Bhai u r a lifesaver😊

[@MaHaNoor-l6s]

Very informative vedio ❤and special thanks for Code 🎉

[@ghanshyamrvaghasiya]

Thank you Boss. You have saved my time.

[@nomanbasharat7382]

Thanks for the code and video. its really helpfull

[@jimmydulatzai]

Great man......God Bless you.

[@healthy-info]

Thank you so much.
Very informative and useful video.

[@shaileshgupta4506]

Very nicely explained. Thanks🍫...God Bless...

[@nitinkamble6308]

Thank you sir for the best video

[@abhijitchakrabarty384]

Excellent ❤ Thank You So Much Brother

[@rajdeepsinh1996]

Thank you sir.. Helpful information it's work

[@anantjosain6816]

Thanks Its working good job done by u

[@pawanvashishth8934]

informative video 👏

[@MohanSontiyal]

Tnx a lot for this informative vdo

[@mohansontiyal3830]

But ek problem aa rhi h jese hm excel m coding dal rhe h to proper Kam kr rha h but excel close krte h or excel again open karte h to wo formula work nhi kr rha h pls solution dijiye

[@lionelusa763]

C Tech, you are wonderful. Good job and keep up. I super appreciate this work.

[@svcprasad]

Wow bro Amaizing

[@hirajaweed]

I really appreciated your work, Jazak Allah

[@vengsaga676]

Useful tips, Thanks.

[@mskhussain]

Great Work Brother....Your video was an Timely help

[@shaikh358]

Great.....thanks a lot

[@speedbrain123]

Thanks for sharing code.

[@k.g.maheshwar]

Bhaiya jee bahut achha jankari diye dhanywad

[@oshinmarya.v1840]

Thank you for this easy explanation

[@vidyadharkumar5701]

बहुत useful वीडियो है। Thanks।

[@DigitalOps-p5v]

gajab guru..maan gaye bahoot badi prob solve kar di

[@Sam-ly2gu]

thank you so much ...this video is very useful for me ....😊

[@skkakar]

Thanks a lot, you solved my problem I was looking for this formula. Regards

[@SanthoshKumar-xy3zm]

Thank you very much Sir🙏🙏🙏🙏🙏

[@maniacmani1969]

Thankyou for the tricks

[@yogeshsalunke127]

Thank you very much, appreciated.

[@uttamchaulagain1138]

Thank You sir.. My problem is solved...

[@gaurangpatel1992]

thanks bro. complete work in my office 2013

[@C-TECH]

Welcome 👍

[@MuntazDoddamani]

salute you sir

[@atulsharma-ho6li]

Thank you sir very useful formula

[@anchorpoint483]

Great work bro, it will very helpful for me

[@caadeshharishshah5812]

thank you sir, very helpful

[@TNSverse]

Thank you so much you are the best.

[@Sindhisongoffical]

It's work thanks 🙏🙏🙏

[@farooqnoor786]

Awesome dear
God bless you, step by step well explained formula
a lot of prayers to you

[@Aleenaartandcraft]

Nice work it's very eazy

[@PradeepKumar-wm6yi]

Thanks sir 👌 problem solved

[@SureshKumar-ld9lc]

Thank you !!! works like charm.

[@AsifKhan-et5fb]

Sir aapki ye video dekh kar mera kam asan ho gaya me bohot TH-cam pe video dekha kisi ka formula kam nahi aata tha par aapka 1 he baar dekha or formula kam aaya thanks for help me aap aise he acche acche video banate raho

[@aniketrohila6590]

thanks for this explained

[@jagiyamanoban8022]

Thankyou so much this vid is a big help

[@JayeshSarankar]

Thank you for sharing..

[@Ramya-ur7of]

Super very useful information thank you 🙂

[@sriraoautoagenciessri88]

GREAT WORK THANK YOU SIRJEE

[@gsureshkumar8698]

Thank you very much sir
Excellent

[@RajanKumar-dh3ox]

thank you so much
really great help

[@RiderHarsh6191]

Thnks a Lot Brother :)

[@rominmenezesromin3]

Very useful bro thank u

[@abhijitmitra184]

Thank you for the coding

[@priyalshah6648]

Bohot mast video hai

[@SantoshGupta-nm2od]

Thankyou for you information

[@ramlaalgaming9424]

Nice... It's working

[@alikhan-gl9gw]

it was easy to understand and it worked just by trying once

[@AtharvGST]

Thanks sir... 🙏🙏

[@govthssezhur732]

Thanks. Good Video

[@IrfanKhan-iz7kd]

Thank you very much sir...

[@NUSRAT1OVR2]

Thanks a Lot dear

[@AjaySagar-kv3el]

GaZB 😍😍😍😍

[@reachcarriers9844]

its very helpful and easy

[@abdulbasitrajpoot8534]

Good effort

[@playstoredaniel]

Than k you Sir. It works.

[@hirengor2909]

Thanks alot for sharing the Codes.

[@samaahmad8877]

where are the codes?

[@abhilashsinha9302]

Excellent! एक छोटे से फार्मूला के लिए कितना बड़ा कोडिंग आपने किया है! बहुत अच्छे!

[@swanandjoshi1992]

Just saw your video and tried in excel, its successful. Thank you so much Sir 🙏

[@s4shan894]

What about coding