Skip to content
Published September 23, 2019

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.

You can Find the Download Link From the bottom of this post. After downloading it, Follow the below instructions to activate 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:

SpellNumber- Launch excel in your computer
SpellNumber- Launch excel in your computer

Launch Microsoft Excel in Your Computer.

 

Step 3:

Click on File > Options.

SpellNumber- Click Options at the bottom of the File Menu
SpellNumber- Click Options at the bottom of the File Menu

 

Step 4:

Click on Addins from the options.

Add SpellNumber Addin as New Addins in Excel
Add SpellNumber Addin as New Addins in Excel

Step 5:

Click on Go where Excel addin is Selected from the drop down menu.

Add Excel Addin in excel
Add Excel Addin in excel

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.

Browse New Addin in Excel
Browse New Addin in Excel

Select it and Hit OK.

 

READ   How To Remove Extra Spaces in Excel?

Step 7:

Finally to activate the addin Click the Checkbox (tick right) in front of spellnumber and Hit Ok.

Check The Spell number Addin
Check The Spell number Addin

Thats it.

 

This is how you add addin in excel.

 

Now go to any cell and Type =Spellnumber() and use it like your regular excel function.

SpellNumber Function Activated
SpellNumber Function Activated

 

Activating SpellNumber Addin in Mac:

To Activate the addin in Mac opereating System Follow the Below steps:

Step 1:

Launch Excel from the applications.

Step 2:

Click on Tools in the Menu Bar and Click on Addins

Step 3:

Click on Go where Excel addin is Selected from the drop down menu.

Step 4:

A New small window will pop up. Select Browse option and locate the location of your Folder in which you saved your Addin.

Select it and Hit OK.

Step 5:

Finally to activate the addin Click the Checkbox (tick right) in front of spellnumber and Hit Ok.

Thats it.

 

Download SpellNumber Addin Here:

For Dollar ($) Currency Download This: SpellNumbersDollars

For Euro Currency Download This: SpellNumberEuros

For Indian Rupee Currency Download This: SpellNumberRupees

For Saudi Riyal Currency Download This: SpellNumberRiyals

For British Pounds Currency Download This: SpellNumberPounds

You can request the currency which you want to work with in the comments below.

 

5 Comments

  1. Sandeep Sakpal Sandeep Sakpal

    hi, i am Sandeep, i have download file spellnumber rupees convert but one of mistake issue is one lakh amount replace of one hundred. because one example (=spellnumber(1,00,000) but wording is One hundred yet.

  2. HUSSAIN HUSSAIN

    hi mr akash good day
    this is hussain from united arab emirates i need same spellnumber addin for AED (DIRHAMS) OUR CURRENCY IF 1,000,000 DHS WE USE TO CALL IT ONE MILLION AED
    SO I NEED IN SAME FORMAT WE ARE HERE NOT USING LAKH WORD
    SO PLEASE IF U FOUND OUT THE TIME THEN PLEASE REPLY AND TRY TO PROVIDE THE NEED
    THANK YOU
    YOUR’S TRULY

  3. Osman Gani Osman Gani

    How do I convert to BDT?

  4. Sumiur Sumiur

    Hi, It’s really good to do work smoothly. Need currency as BDT (Bangladeshi Taka). Please help to get. Thanks a lot.

Leave a Reply

Your email address will not be published. Required fields are marked *