filmov
tv
Convert Number To Words in Excel || Convert Numbers to Words in Rupees: No Macro No Coding

Показать описание
In this Video we will learn How To Convert Number To Words in Excel || Using SpellNumber Formula Convert Numbers to Words in Rupees: No Macro No Coding, alos 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, Easily convert a numeric value into english words [ indian rupees ]. MS Excel does't have any inbuilt feature to convert number to word [ text ] in excel - but we can convert any amount or number into word [ indian rupees ] in MS excel using spellnumber formula Learn How to Use spellnumber formula to convert any number into words :
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.
Download File location
Download SpellNumber Excel File:
Download VB Coding File:
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.
Hit the the follow and like button, comments on this also share with your friends...
also Subcribe my youtube Channel..
#SpellNumber
#ConvertNumberstoWords
#masif516
Stay Tuned for latest updates...
Thanks for watching this video,,,
For More Videos
1)How to Print from Any Printer in Android | without wifi Printer | Google Cloud Printer by Jam Asif
2) How to Print from Any Mobile iPhone or Android to hp Printer | E Print by Jam M Asif
3) How to Remotely Control your PC/Laptop by Using Mobile Phone | (Iphone or Android)
4) HOW TO CONNECT CCTV CAMERA TO (ANDROID OR iPHONE) MOBILE / LAPTOP | STEP BY STEP.
5) Download Any Video With iPhone & iPad on Any iOS | Save in Your Camera Roll | Without Jailbreak
6) Jazz Caller Name Service | Show The Name of Unknown Caller without Internet or Any App | Code Review
7) How to Connect WiFi Without Password in Mobile | Use WiFi Without Password | by Jam Asif
8) Scan documents with your Mobile, and get print, by Jam Asif
9) How to Setup Whatsapp on PC and Laptops Officially | Jam Asif
10) Unlock All Locked Apps Without Password | for Your Mobile | jam Asif.
11) Jazz Caller Name Service | Show The Name of Unknown Caller without Internet or Any App | Code Review
12) How to Download Videos from Facebook and YouTube [Without Using Any Software]
13) How to Install Whatsapp on PC without Bluestacks or Youwave |windows 7/8/8.1/10 |by Jam Asif
14) 2018. Best App Locker for Your Mobile | Hide Your Photos, Videos | App Review
15) How To Use Mobile Internet On Your PC Via Usb Cable - USB Tethering
Thanks
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, Easily convert a numeric value into english words [ indian rupees ]. MS Excel does't have any inbuilt feature to convert number to word [ text ] in excel - but we can convert any amount or number into word [ indian rupees ] in MS excel using spellnumber formula Learn How to Use spellnumber formula to convert any number into words :
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.
Download File location
Download SpellNumber Excel File:
Download VB Coding File:
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.
Hit the the follow and like button, comments on this also share with your friends...
also Subcribe my youtube Channel..
#SpellNumber
#ConvertNumberstoWords
#masif516
Stay Tuned for latest updates...
Thanks for watching this video,,,
For More Videos
1)How to Print from Any Printer in Android | without wifi Printer | Google Cloud Printer by Jam Asif
2) How to Print from Any Mobile iPhone or Android to hp Printer | E Print by Jam M Asif
3) How to Remotely Control your PC/Laptop by Using Mobile Phone | (Iphone or Android)
4) HOW TO CONNECT CCTV CAMERA TO (ANDROID OR iPHONE) MOBILE / LAPTOP | STEP BY STEP.
5) Download Any Video With iPhone & iPad on Any iOS | Save in Your Camera Roll | Without Jailbreak
6) Jazz Caller Name Service | Show The Name of Unknown Caller without Internet or Any App | Code Review
7) How to Connect WiFi Without Password in Mobile | Use WiFi Without Password | by Jam Asif
8) Scan documents with your Mobile, and get print, by Jam Asif
9) How to Setup Whatsapp on PC and Laptops Officially | Jam Asif
10) Unlock All Locked Apps Without Password | for Your Mobile | jam Asif.
11) Jazz Caller Name Service | Show The Name of Unknown Caller without Internet or Any App | Code Review
12) How to Download Videos from Facebook and YouTube [Without Using Any Software]
13) How to Install Whatsapp on PC without Bluestacks or Youwave |windows 7/8/8.1/10 |by Jam Asif
14) 2018. Best App Locker for Your Mobile | Hide Your Photos, Videos | App Review
15) How To Use Mobile Internet On Your PC Via Usb Cable - USB Tethering
Thanks
Комментарии