SPELLNUMBER: Convert Numbers To Words in Dollars in Excel?
SPELLNUMBER Convert Numbers To Words in Dollars in Excel

SPELLNUMBER: Convert Numbers To Words in Dollars in Excel?

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.

More Details   6 Most Common Errors of Excel: How to Solve Them?

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.

 

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.

 

Akash Gurjar

Hi, I am Akash. I am Hobbyist Blogger and YouTube Creator. I like to explore and learn new things all the time. I own a website easyexplain.info and a YouTube Channel EasyExplain. Join Me.

This Post Has 48 Comments

  1. 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

    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

    1. Mahesh Raj Varma

      Mr. Akash Good Day to you, I am one another guy also looking for solution of above mentioned problem by Mr.Hussain. also pls. note decimals are called fils in Dubai/UAE.
      example: 1,000,000.50 (in words Dirhams One Million and fifty fils only).
      awaiting for your kind feedback.

  3. Osman Gani

    How do I convert to BDT?

    1. B hal

      Your formulas is good. But not work in 2nd time or new excel sheet. So please reply in email for more discuss.

  4. Sumiur

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

      1. Nandita

        Hi dada, I also want this file with BDT form and only spell . I mean without any currency. It will just spell the number. Can you please help me?

  5. Nishit Patel

    i wont spell number file in Tanzanian shilling

  6. Saidur

    Dear Sir
    Thank you very much for you very very helpful creation.I need spellnumber fo Dirhams (AED).If you provide me it will be very kind of you.

  7. Arshad Mehmood

    hi how are you
    please tell me how can I convert numbers to words as Kuwaiti Dinars&Fils
    because 1000 Fils = 1 Kuwaiti Dinar
    for example 235.750 its two hundred thirty five Dinars and seven hundred fifty fils
    please explain if you know
    thanks

  8. ullas

    Hi Mr akash Gurjar good day
    this is ullas from united arab emirates i need same spellnumber addin for AED (DIRHAMS AND FILLAS)
    pls

  9. SAICHARAN PULIGILLA RAJ

    can you forward the easy spell for Dir hams UAE

  10. Tshering Dendup

    hi sir
    it is me tshering dendup from Bhutan
    i want to say that would you share me in our currency i.e
    in your country it is rupees but in our country is ngultrum
    instead of
    rupees i want ngultrum and paisa i want chhetrum
    looking forward for your kind support please.
    thanks

  11. naveed

    i need spellnumber addin pak rupee

  12. PRAMOD AGRAWAL

    works good while creating direct same formulae through office 365 website copy and paste does not work.

    further more it sound like one thousand rupees while it should be Rupees or Rs.or symbols of INDIAN CURRENCY THEN END WITH “ONLY”
    like
    Rupees One Thousand only or Rs.one thousand only

  13. Naw Mai Mwijang

    Dear Sir
    Thank you very much for you very very helpful creation.I need spellnumber for Myanmar (KYAT).If you provide me it will be very kind of you.

  14. nasr

    sir i need Dirhms and fils ( UAE Currency File) instead of Dollar and Cents.

    Please send me this file. i will be highly appreciated for you for sending me this file

  15. Pulok Reberio

    Hello Brother,
    It’s really very fantastic for work in Microsoft Excel. I need your help to do my work more easily. Please change the currency Rupee to Taka or TK. and Paise to Poysha.
    Thanks in advance for support.

  16. Gangareddy Challa

    Dear sir, Good Morning
    I need this in indian currency like crores,lakhs, thousands, hundreds and paisa . And also start with Rupees & end with only.Kindly help me. Thankyou sir.

  17. Mohammad Abdul Halim

    Excellent

  18. Mohammad Abdul Halim

    I need covert Taka

  19. Hitesh

    i want the file in Aed Or Dirhams for UAE currency and also instead of Lakhs i want in thousands and millions

    please help

  20. Hitesh

    Also please if you can mentioned Dirhams in the beginning

  21. Prabal Chatterjee

    Hi This is Prabal,

    Please help me to Convert Spellnumbers in DJIBOUTI FRANKS (DJF)

    let’s say DJF 1,500,200.40 = One Million Five Hundred Thousand and Two Hundred point Forty Djibouti Franks
    or 1,500,200.00 = One Million Five Hundred Thousand and Two Hundred Only

  22. GAURAV VERMA

    bhai nahi ho raha hai eror aa rahi hai #NAME?

  23. KY12

    Would appreciate for currency of Ringgit Malaysia and Sen. Tyvm

  24. anil

    i want to use spellnumber for Inr as well as Euro. Is it possible to use these two formula at a time in one sheet

  25. kwaku

    i need spellnumber addin cedis

  26. Gopal

    I need spellnumber file with currency “Dirhams”

  27. Muhammad

    I need spellnumber file with currency “Dirhams”

  28. Sujan Maharjan

    I want spell number in Rupees and Paisa

  29. Dider Uz Zaman

    Sir,
    I need covert Taka.
    Thanks in advance.

  30. Dider Uz Zaman

    Sir,
    I need covert Taka. Like as follows:
    Tk. 11,012,548.68
    One Crore Ten Lac Twelve Thousand Five Hundred Forty Eight Taka & Sixty Eight Paisa Only.
    Thanks in advance.

  31. Dider Uz Zaman

    Dear Sir,
    I need convert to Bangladeshi Taka.
    Like as 1,23,45,678.90 One crore twenty three lac forty five thousand six hundred seventy eight Taka & ninety paisa only
    Thanks in advance.

  32. HASAN

    hi, boss Good Effect. but want currency dirham (AED)

  33. Vijay

    Hi Akash. I need this function in Qatari Riyals (QAR)
    Thanks in Advance.

  34. Sibtain

    need to spell number in dirham

  35. Joseph

    Hi. I require the spellnumber file in AED, as you have put dollars/Rupees etc

  36. Barkath

    Hi sir. i Need to spell Number in Ringgit

  37. pradeep

    I want to need spell number in indian

  38. Sourav

    Very Good Morning…after amount i want to use only..how to do it?

  39. DANVEER

    Hi Akash Ji,

    How r u? I am using Excel -2007. I want add spellnumber addin into my excel sheet.

    Regards
    Danveer singh
    Cell no 7678453432 (Whatsapp)

  40. Rukmuddin

    Hi Bro,

    I need Spell numbers in UAE Dirhams

Leave a Reply