SPELLNUMBER: Convert Numbers to Words in Dollars, Rupee, Euros, Riyals in Excel No Macro - No Coding

preview_player
Показать описание

#Spellnumber #EasyExplain #AkashGurjar
Today We will learn How to convert Numbers to Words in Dollars using SPELLNUMBER Function in Excel. Spellnumber Function is a UDF (User Defined Function) in Excel.
Therefore,By Default Spellnumber Function is not activated, You have to activate it using VB Scripting. But we are not going to Learn any scripting here.
You only need to know How to Download any File from Internet?, How to copy and Paste a File?
Thats it.In the later part I will show you What to Copy and Where to paste.
As I said before, You can convert any numeric value to Words in excel using excel.
Let’s do it.
How to Use Spell Number Step by Step in WIndows 7, Windows 10?
Step 1: Save SpellNumber File in your Computer:

Create a New Folder in your Computer Where you want to save Your Addins. I created a new folder in “My Documents”, Copy and Paste the Downloaded File in same folder.

Step 2: Launch/Open Microsoft Excel
Step 3: Click on File -Options.
Step 4: Click on Addins from the options.
Step 5: Click on Go where Excel addin is Selected from the drop down menu.
Step 6: A New small window will pop up. Select Browse option and locate the location of your Folder in which you saved your SpellNumber Addin.
Step 7:Finally to activate the addin Click the Checkbox (tick right) in front of spellnumber and Hit Ok.
Convert Numbers To For Dollar ($) Currency in Excel Download This: SpellNumbersDollars

Convert Numbers To Euro Currency in Excel Download This: SpellNumberEuros

Convert Numbers To Indian Rupee Currency in Excel Download This: SpellNumberRupees

Convert Numbers To Saudi Riyal Currency in Excel Download This: SpellNumberRiyals

Convert Numbers To British Pounds Currency in Excel Download This: SpellNumberPounds

You can request the currency which you want to work with in the comments below.
Рекомендации по теме
Комментарии
Автор

Sub kar diya bell icon press kardi aur bolo gurjar saab..

avnitechindia
Автор

Excellent stuff! Thank you for sharing your knowledge.

helenshukla
Автор

Thanks for your excellent presentation. We need SpellNumberTaka

reximesales
Автор

Sir ji Jaise aap ho smart waisi computer class v karate ho smartly

ziyaummar
Автор

Thanks for your video. I need numbers in word formate but with any currency. Can you please make it for me. Thanks.

emaskstudio
Автор

Hello. Great job. Thanks for sharing, I need to change currency to Rupees and cents using thousand, million etc instead of lakh. And is it possible to insert the sum in word in the middle of a text in excel?

ajaysobha
Автор

HI, Thanks for your video on number conversion.
I see that only one currency can be used at a time.

Is it possible to use two currency at at time. For example I want to use INR for one excel file and Dollars for another file. How do we do the add in and give reference in the excel sheet cell.
Thanks

aslatheef
Автор

bro... thank you. your video is very helpful. can you please share code in Qatar Riyal (QAR)

abdlkk
Автор

very nice stuff . Please i required OMR currency of oman

SaqibAli-hucr
Автор

Can I get the same as in words in UAE Currency (Dirhams) as well? Also, can you add "only" in the last

pramiladsouza
Автор

If we want to use both usd and other currency

fakhrikbw
Автор

Thanks Brother, Can i get the same like in words " dollars and Cents xxx only" and can i get in UAE Currency as well

sumitchaudhary
Автор

Bro, pls help by sharing the link for Dirhams (AED)

sajeevathanikkal
Автор

you have given spell numbers for separate currencies but I want spell numbers for all currency in one spell number,
kindly suggest.

rgaleshkumar
Автор

Hi Can you please do the same coding for Omani Riyals. Thanks

sivaveeraIN
Автор

Sir I want to convert number into words in UAE currency ie AED or Dirhams

jamalislam
Автор

How to apply spellnumber function on formulated cell with INR currency name in the beginning.?

joybrahmbhatt
Автор

Hello Sir,
I want to add "Only" at the end of the amount/numbers in the word. can you please help me on this ?

yuvarajadhikari
Автор

Dhirams spell number available pls make one videos

rajae
Автор

Doesnt works when excel is restarted.... any solution for it. I am using excel on windows 10

atul