Excel Formula to convert Numbers to words in Rupees: No Macro No Coding

Excel Formula to convert Numbers to words in Rupees: No Macro No Coding | SPELLNUMBER Function

Рет қаралды 1,419,352

6 жыл бұрын

In this Video we will learn a formula in MS Excel to convert numbers or digits into words in Rupees by copy pasting only. Excel does not include this function in its functions library but by using VB Script and Macro enabled worksheet you can enable this function in excel.
You can do this by applying SpellNumber Function in MS Excel
Using Macro enabled worksheet is a temporary solution because you have to copy and paste the code in VB script and save your file as a macro enabled workbook.
So I decided to go a step further and found a Permanent solution to use SpellNumber Function forever.
All You need to download this file at:
drive.google.com/file/d/1mr7n...
And save it to this Location: C:\Users\User_Name\AppData\Roaming\Microsoft\AddIns
After adding this file to the given location, you don’t need to save your workbook to a macro enabled workbook everytime. You can save it as you like in .XLS format.
The most rich benefit of this method will be availability of this function anytime you want to apply in workbook.
Is video me hum dekhenge or smajhnege ki excel me numbers yani ki digits ko words me kis tarah se convert kiya jata hai vo bhi sirf kisi file ko download kar ke or save kar ke.
#SpellNumber
#ConvertNumberstoWords
#EasyExplain
More Related Videos:
Top Useful Internet Tricks You Should be Using in 2018 • Top Useful Internet Tr...
IF Function in Excel in Hindi | Simple and Easy • IF Function in Excel i...
Datally app: Now Save Data Upto 30% for Free in Hindi • Datally app: Now Save ...
Best Excel Shortcuts to Work Faster in Hindi • Best Excel Shortcuts t...
How to use VLOOKUP in Hindi - Easy to use in Simple way. • How to use VLOOKUP in ... For More Interesting Stuff Visit to My new website: mytoptenlist.in

Пікірлер: 2 100

@ayazquamer4261 9 сағат бұрын

It's not showing lacs instead it's writing one hundred twenty five thousands like that

@rspthatal 3 жыл бұрын

Thank you. This is wonderful and very awesome. I just have a one query. There should be space between Ninety Four but it is coming as NinetyFour. Is it possible to resolve.

@VijayTorane-lq5dr

Sir - formula given by you is excellent but I have doubt when the figure in lakh ex. 1,20,000/- then its shows in word as "one hundred twenty thousand rupees" instead of "ONE LAKH TWENTY THOUSAND RUPEES". Will you please suggest how to do this....

@lusekelomwakyembe6052 6 жыл бұрын

Doesn't work on latest excel version

@000007891 5 жыл бұрын

When I need different currency that time how I use it?

@rochakmehta90 6 жыл бұрын

I assume it's an add on ..which is pre coded...means your title say wrong...it's coded...

@arif1sindhi140 4 жыл бұрын

NICE BRO.......

@MrSundar79 4 жыл бұрын

Super ji working fine

@royalbikascreation5846 4 жыл бұрын

Awesome teching bro

@ankurjain8694 6 жыл бұрын

Sir aapne to permanent salutation kar diya he

@luckyflp43 3 жыл бұрын

Friday, 23 July 2021:-

@maheshbyd 3 жыл бұрын

Thanks for the video. I tried many videos here in youtube. But as you said they were complicated. But this is very simple and easy. Thanks again

@VivekSingh-to1lv 4 жыл бұрын

It works only when I am adding the Addins everytime I am opening up new excel workbook. And whenever I reopen the sheet in which I have used spellnumber, it shows

@luckyflp43 3 жыл бұрын

शुक्रवार, 23 जुलाई 2021:-

@naveenrozario2944 5 жыл бұрын

You have made it so simple.Thank You so much from my heart

@Alikhan-no8sk 4 жыл бұрын

Hello if want to convert in other currency except rupees like dollar

@sairaaslam3292 3 жыл бұрын

Thank u so much ..baqi sab ne aisa sikhaya k MACRO file krna par raha tha .new workbook pe wo apply nahi hota ..phir se proceed krna parta .ya bohat tricky kr rahe thay...ap ne bohat awesome way se sikhaya k " SYSTEM MEIN HI DOWNDLOAD KR K EXCEL KA HISSA BANA DIA ...