Excel Formula to convert Numbers to words in Rupees: No Macro No Coding | SPELLNUMBER Function
1.4 میلیون بار بازدید -
7 سال پیش
-
In this Video we will
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:
https://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 Tricks You Should...
IF Function in Excel in Hindi | Simple and Easy IF Function in Excel in Hindi | Simpl...
Datally app: Now Save Data Upto 30% for Free in Hindi Datally app: Now Save Data Upto 30% f...
Best Excel Shortcuts to Work Faster in Hindi Best Excel Shortcuts to Work Faster i...
How to use VLOOKUP in Hindi - Easy to use in Simple way. How to use VLOOKUP in Hindi - Easy to... For More Interesting Stuff Visit to My new website: http://mytoptenlist.in
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:
https://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 Tricks You Should...
IF Function in Excel in Hindi | Simple and Easy IF Function in Excel in Hindi | Simpl...
Datally app: Now Save Data Upto 30% for Free in Hindi Datally app: Now Save Data Upto 30% f...
Best Excel Shortcuts to Work Faster in Hindi Best Excel Shortcuts to Work Faster i...
How to use VLOOKUP in Hindi - Easy to use in Simple way. How to use VLOOKUP in Hindi - Easy to... For More Interesting Stuff Visit to My new website: http://mytoptenlist.in
7 سال پیش
در تاریخ 1396/09/30 منتشر شده
است.
1,413,668
بـار بازدید شده