Comments on: Two best ways to convert numbers to words in Excel

In this article I will show you two quick and free ways to convert currency numbers into English words in Excel 2019, 2016, 2013 and other versions. Continue reading →

Comments page 19. Total comments: 530

  1. How to insert Rupees instead of Dollar and Paise instead of Cent in the outcome from above =spellnumber() function ?

  2. By this Indian rupees and paise is not convert in words.Plz solve this problem.

  3. great it worked for me perfectly

  4. HI, im unable to understand and work the formula pls help..

  5. I want to convert numeric value with word form without any currency.
    Pl help me

    1. Dear, i also need same as you are demanding.please provide me same function if you have,
      thanks

  6. You can also do it by my function :

    Option Explicit
    Option Base 0
    'Author: thaipv@live.com
    'Date: 30/11/2014
    'Reference: https://support.microsoft.com/kb/95640
    'More: http://www.techonthenet.com/excel/formulas/curr_to_words.php
    Function READNUMBER(ByVal CNUMBER, Optional UPPER As Boolean = True) As String
    Dim DIGIT, ATEEN, ATENS, PLACE(13), READ1__$, READ_23$, READ123$
    Dim NUMBER1 As Byte, NUMBER2 As Byte, NUMBER3 As Byte, V As Byte

    DIGIT = Array("", " one", " two", " three", " four", " five", " six", " seven", " eight", " nine")
    ATEEN = Array(" ten", " elevent", " twelve", " thirteen", " fourteen", " fifteen", " sixteen", " seventeen", " eighteen", " nineteen")
    ATENS = Array("", "", " twenty", " thirty", " forty", " fifty", " sixty", " seventy", " eighty", " ninety")
    PLACE(1) = " trillion,": PLACE(4) = " billion,"
    PLACE(7) = " million,": PLACE(10) = " thousand,"

    If Trim$(CNUMBER) = "" Then
    READNUMBER = ""
    ElseIf Not IsNumeric(CNUMBER) Then
    READNUMBER = "(ò_ó) Hmm, It is too embarrassing! XA can not read this number: " & "'" & CNUMBER & "'"
    ElseIf CNUMBER 10 ^ 15 Then
    READNUMBER = "(ò_ó) Hmm, It is too embarrassing! This number is too large to read."
    Else
    '// Doc dau am/duong cua so tien va xy ly so tien truoc khi doc//
    READNUMBER = IIf(Round(CNUMBER, 0) < 0, "minus", "")
    CNUMBER = Round(Abs(CNUMBER), 0): CNUMBER = "000000000000000" & CNUMBER
    CNUMBER = Replace$(CNUMBER, ",", ""): CNUMBER = Right$(CNUMBER, 15)

    '// Bat dau doc so //
    For V = 1 To 13 Step 3
    NUMBER1 = Mid$(CNUMBER, V, 1)
    NUMBER2 = Mid$(CNUMBER, V + 1, 1)
    NUMBER3 = Mid$(CNUMBER, V + 2, 1)
    READ123 = ""
    READ1__ = IIf(NUMBER1 = 0, "", DIGIT(NUMBER1) & " hundread")
    Select Case NUMBER2
    Case 0: READ_23 = DIGIT(NUMBER3)
    Case 1: READ_23 = ATEEN(NUMBER3)
    Case Else: READ_23 = ATENS(NUMBER2) & DIGIT(NUMBER3)
    End Select
    READ123 = READ1__ & READ_23
    READNUMBER = Trim$(READNUMBER & IIf(Len(READ123) = 0, "", READ123 & PLACE(V)))
    Next V

    '// Xu ly (nhung) dau phay (",") du thua va VIET HOA chu dau tien //
    READNUMBER = IIf(Right$(READNUMBER, 1) = ",", Left$(READNUMBER, Len(READNUMBER) - 1), READNUMBER)
    READNUMBER = IIf(UPPER = True, UCase$(Left$(READNUMBER, 1)) & Mid$(READNUMBER, 2), READNUMBER)
    End If
    End Function

  7. Dear
    We are working in Oman .SO can you please send us the VBA MICRO code for Oman Currency.We write omani currency in three decimal palce
    e.g 450.560 four hundred fifty Rials and five hundred sixty Baiza.
    Pease help me to convert nuemerical Omani currencyin word in excel.
    WITH REGARDS
    MOHAMMED IFTEKHAR AHMED

  8. DEAR FRIENDS, CAN I HAVE THE SAME THAT CAN AUTO SELECT CURRENCY ,,

    SOMETIME IT MAY BE IN USD, EUR, AED, SAR, KWD
    AND SO ON . SO HOW TO ENABLE THE FORMULA FOR MULTIPLE CURRENCY ..

    THANKS

  9. THANKS

  10. how to the change the format to Lakh & Crores instead of Million & Trillion

    1. I need your help,
      Please know me Lac & Croers formula,
      very urgent your co operation.
      Best Regards
      Samir.
      Dhaka.

  11. Hi! Thanks for the formula. It works, I have created the VB formula. But I Just need "Ten Thousand" rather than "Ten Thousand Dollors And None Cents?"

  12. I need help from some excel masters. I need excel convert from numbers like $1234.50 ...to text, but writing the cents in the form of 50/100 and word USD at the end...I would really apreciate somebody share this trick please.

    1. Hi have u solve this problem? Help plssss

  13. Hi, how can I convert 1,547.50 into "One thousand five hundred forty seven and cents fifty only"?

  14. Very great. Kudos to all who contributed to this knowledge sharing medium. However, it can be improved upon by adding seperators in form of commas ','. For example, converting $1,500.00 into words would be 'One thousand five hundred dollars' rather than 'One thousand, five hundred dollars'.

  15. GREAT HELP . THANKS

    THE WORD """DOLLARS""" AND """CENTS"""

    YOU CAN ALSO USE THE CURRENCY OF YOUR COUNTRY LIKE

    I USE................. """RUPEES""" AND """PAISA"""

    AND ITS WORKING FINE..............

    FOR PAKISTANI CURRENCY..............

  16. how can i change from Dollar to Saudi Riyal

    1. JUST SEARCH IN VB ""DOLLARS""""" REPLACE WITH """SAUDI RAYAL"""

      SIMPLE

  17. plsss....I tried it.... but I got error message... LOOP WITHOUT DO.....plss..kindly send the excel file to my mail..... ifelekods @gmail.com. thanks

  18. I need to convert on checks a number without the dollar sign to words with a dollar sign. Can you send me a spread sheet with a working module. I copied and pasted but get a pop up on the VBA. Thanks

    1. USE Rahim Zulfiqar AlI'S FORMAUL AND COPY PASTE THE RESULT AS TEXT AND MATCH IT WITH THE ADDITIONAL THAT YOU WANT IT BE REDA WITH

  19. Hi there,

    I really need to fix the format on the big numbers to say "thiry thousand five hundred AND Ninty dollars and fifty four cents"
    I need the AND after the five hundred... please help, I just what to know where to fix the code...

  20. thanks it works

  21. Hi Kudzi

    Tried yr formula but was fail. What do you mean by "NUMBERVALUE"?

    Best Regards.

  22. we convert in indian currency e.g 12(tweleve) in this way not dollar

  23. Superb

  24. how if we don't want the words "dollars" in our converted sentences.. Pls show me the module, Thank you so much.

    1. if i no need "dollars" what should i do ?
      the thing i want (1001.10=One thousand one point ten) who know
      pls help me.
      thanks

  25. If you have added the add in like Nick T instructed above, but you say you are filling a checque in excel and you would want

    e.g 4000 to be "four thousand dollars only" and not "four thousand dollars and no cents" but you would also want 4000.36 to be "four thousand dollars and thirty six cents only" when there are cents added.

    lets say the number you want to convert is in cell "B" use the following formula

    '=IF(NUMBERVALUE(RIGHT(B6,2),".",",")>0,CONCATENATE(UPPER(SpellNumber(B6))," ONLY"),CONCATENATE(LEFT(UPPER(SpellNumber(B6)),LEN(UPPER(SpellNumber(B6)))-12)," ONLY"))

  26. thanks Nick T

  27. I came across an article on another site, to embed this function permanently into Excel, without it being a macro and creating opening and saving nightmares.

    Similar process as listed above, and as you may have seen before, but with a twist...

    >> Open a blank workbook in Excel
    >> Hit ALT-F11
    >> On the top menu, select Insert>Module
    >> Copy and paste the above mentioned VBA code (from the original post, way up top)
    >> Back in VBA, on the top menu, select File>Save Book#
    >> Once in the Save As menu, go down to "Save as type:", click the down arrow, and select "Excel Add-In"
    >> Type a file name of your choosing, (I chose SpellNumber) and choose a file location you'll remember. (the predefined location will work just fine, but you may want to note the location, just in case.
    >> Close out of the VBA editor
    >> On the top main Excel menu, select File>Options
    >> In the Excel Options menu, on the left side, select "Add-Ins"
    >> In the Add-ins menu, at the bottom, under "Manage:" click the down arrow, and select "Excel Add-ins", and then click "Go..."
    >> In the subsequent Add-ins menu, on the right side, click "Browse..."
    >> In the Browse pop-up, you may or may not see the add-in that you previously created and saved. If you see it, select it and click OK. If you do not see it, navigate to the location where you saved it, then select the file and click OK.
    >> Now back in the previous Add-ins menu, you will see your Add-in in the list. If it's box is not checked, click to check it at this time, then on the right, click OK.
    >> Your Add-in will now load every time you open Excel, allowing you to use and perform this function all the time. Also, it is now an add-in, not a macro, so will not create the hassles macro-enabled workbooks carry.
    >> To actually use the function, simply start typing =Spellnu the function should auto populate. Double-click the popup, select the cell you want spelled out, close the parenthesis ), and voila!

    1. Indeed! It works!

      Thanks for this!

    2. Thank you NickT, this helped me at work a lot. I have a question tho, I've been playing with the macro functions but i don't seem to be able to get the fills/cents in this format "50/100" "30/100" "89/100" do you have a function i can use for it?
      In the link https://goo.gl/tdBmGQ is the current macro i used as i don't want any currency, also i wanted the word only at the end but i manage that just adding & only at the end it works as well, so not too important that one.
      I would really appreciate if you could help me out with that function.

      Many many thanks!!!!

    3. Dear Mr. Nick T, What should I change in this formula if I Have to write the word for example Taka 9,875 (Taka Nine Thousand Eight Hundred and Seventy Five Only ) ? would You likely to help me to get rid off it ? Thanks

    4. Thnku.. Nick T...It works..

      1. nick how can i change the currency into peso..

        thank you.

        1. Hello change all "dollars" into pesos

          works for me

  28. your solution is amazing but i wonder if i just want the number as it is without dollars without saudi rayal without any currency name , how can i do that in the module

  29. if my number is $500.07 and my word want to convert to "Say Dollars Five Hundreds and cents Seven Only). What is the format for this?

    1. Thanks for your help...

    2. You need to customize the macro a little bit. I am sorry all our technicians are overloaded with work at the moment and can't help you with this. Please look for the solution on these forums: http://www.Mrexcel.com or http://www.excelforum.com

  30. can you please provide me the easiest way to find spellnumber to convert numbers to words

  31. very helpful thanks indeed

  32. hi sir
    please help me to do spellnumber code in check format

    Ex. if i type $1,000.15
    it will be ***One Thousand Dollar and 15/100 Only***

    im so glad if you help me

    thank you :D

  33. There is some Error in this formula becouse the every time after close Excel file then we open next time file we have need to microsoft visual basic for application and save the same seting again and agian. we want to that after one time save the setting the formula contuning in work.

  34. Hi! Thanks for the formula. It works, I have created the VB formula. But what should I do if I only want the words "Six Only" rather than "Six Dollars and None Cents?"

    My currency happens to be different so I prefer without the currency in words. Thanks!

    1. Change the Dollars & " Dollars" to Dollars only without quotation marks mean give only variable name and & to forward part be omitted.

  35. You can also do it by Formula:

    =TRIM(IF(A2=10^5,CHOOSE(FLOOR(MOD(A2,10^6)/10^5,1)+1,"","One","Two",Three","Four","Five","Six", "Seven","Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen",
    "Seventeen","Eighteen","Nineteen")&" Hundred","")&IF(MOD(A2,10^5)>=20000," "&CHOOSE(FLOOR(MOD(A2,10^5)/10^4,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety")&IF(MOD(MOD(A2,10^5),10^4)>=10^3," "&CHOOSE(FLOOR(MOD(MOD(A2,10^5),10^4)/10^3,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen", "Seventeen","Eighteen","Nineteen"),""),IF(MOD(A2,10^5)>=10^3," "&CHOOSE(FLOOR(MOD(A2,10^5)/10^3,1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&" Thousand") & IF(A2=10^2," "&CHOOSE(FLOOR(MOD(A2,10^3)/10^2,1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen", "Seventeen","Eighteen","Nineteen")&" Hundred","")&IF(MOD(A2,10^2)>=20," "&CHOOSE(FLOOR(MOD(A2,10^2)/10,1)+1,"","","Twenty","Thirty","Forty","Fifty","Sixty", "Seventy","Eighty","Ninety"
    )&IF(MOD(MOD(A2,10^2),10)>=1," "&CHOOSE(FLOOR(MOD(MOD(A2,10^2),10),1)+1,"","One","Two","Three","Four","Five","Six", "Seven","Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen", "Seventeen","Eighteen","Nineteen"),""),IF(MOD(A2,10^2)>=1," "&CHOOSE(FLOOR(MOD(A2,10^2),1)+1,"","One","Two","Three","Four","Five","Six","Seven", "Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen", "Eighteen","Nineteen"),""))&""))

    1. I have tried and it was successful. But it was all in dollars.. How about in Qatar Riyals? How can i do it? Can you feed the module formula?

    2. Dear, can you please share the excel with formula... it would be very helpful in my project.

      I am looking for a formula not a vb code. Thank you.

    3. this formal is not working my email address is kishor.0088@gmail.com

    4. Can you also send me a copy of your excel file. Please. It will help me a lot with my project.

    5. Yes it is working. But not reading Hundred.?
      Reply me

    6. How would you trim this formula down if you're only using whole numbers between 1 and 12?

    7. I'm really sorry, when you posted the formula, an error occurred. So and pasting it to Excel directly doesn't work. Please send us the working copy in an Excel file. I will be happy to add your formula to the article and sign it with your name.

      1. Good morning, pls send me the formular as well.

        Thanks
        Ibrahim

      2. Email ?

      3. Please let me have your email so that I can send you my excel file for you to insert your formula to convert number to words
        Thanks a million
        Stephen

        1. please send above said excel file

        2. Kindly send me also a copy of that formula thanks

          Please need it asap

        3. Sir Please send me excel File.
          I Shall be thankful to You for this act of kindness.

        4. Please send me the formula!

        5. Dear Stephen,

          please send me excel sheet for converting same

        6. Dear Stephen Please if you can send me same excel file in my email.I will be thank full to your great support.Thanks Ali Khan

        7. Please send me same excel sheet with formula,

          Many Thanks

        8. I shall be very thankful to you if you send me excel file

        9. Please send us the working copy in an Excel file. I will be happy to add your formula. My email address is
          digital851@gmail.com

          1. Hi,
            Please send me also this formula

          2. Email sent.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)