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 7. Total comments: 537

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

  3. Please email formula convert number to word

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

  5. Many thanks to admin

  6. Please email formula convert to Ringgit Malaysia (RM)

  7. Please kindly send me the formula also.
    Many thanks.

  8. Please send me also

  9. I have follwed your instruction & But still the error as #Name is apprearing on the spell number formula. please help

  10. Thnks for ur help. Its been a pleasure to have guidance.

  11. Very useful and clear explanation. 5 Star:D
    Thank you for sharing this information with us.

  12. Dear sir, please how to make wordstodigit formula details

  13. Please send me the excel sheet for converting dollars to words. I tried to paste from an earlier Spellnumber post using VBA but I get a #Name error.

    Thank you.

    1. The VBA code from the example above works perfectly when we try it. Please, repeat the steps from the tutorial making sure that you paste the code without losing any lines, and save your document in the proper way as it is described. If this still doesn't help, try our add-in. If the error won't disappear, send us your workbook and the link to this article and your comment to support@ablebits.com.

  14. It is very simple to convert dollar into your currency for example if you have a Rupee go to Module (micro-soft visual basic) enter Ctrl + R just replace dollar and cent with your currency.

    Thanks for more details kindly contact on my email. asifashraf930@gmail.com

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

  16. What if I would like to put a special name?
    ex. for 100 will be "clint"

    Therefore,
    100 = Clint
    150 = Clint Fifthy
    123 = Clint Twenty Three
    etc..

    NB: Only for "100"

  17. Hi all,
    Can someone assist me to write
    1020 as one thousand and twenty not one thousand twenty please.
    Thank you in advance

    1. Just put "and ..." on GetTens' function, dude

  18. Working done ,
    after save i close this file again open try modify and try change then its showing error

  19. how to delete the rows using check bos in excel.

  20. Thank you! Copied and pasted the module, saved my file as an .xlm and bada-boom!

  21. Dear Sir please send me the copy of these excel sheet please ,as soon as possible , please please

  22. Dear . Alexander Frolov
    Thanks for the formula, its works nicely

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

  24. How can we split the amount in words into 2 lines in case 1 line is not enough to accommodate the amount in words? This is needed when printing on pre-printed cheque leaves.

    Can anyone please help on the above?

  25. Can i get modules for spellnumbers in words with cents. I have those modules with currency. But i'm using multi currencies so i don't want modules with currencies. Please help email me the modules which i request. Urgent. Please and Thanks.

    Regards,
    Puvanah

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

    Thanks
    Ibrahim

  27. Please the code to convert amount to words is excellent, only i think there's something missing. after the code is pasted in Excel Module, and you key-in 420, the result that comes is: Four Hundred Twenty Dollars and No Cents. But am expecting Four Hundred and Twenty Dollars and No Cents. This means the an "and" is missing in-between Hundred and twenty. Thank you and looking forward to hear from you soon.

  28. i use the module, but our central bank required us to put a "ONLY" word in the end of the Check. how can i do this?

  29. Hi Sir,

    I am very much need the program that convert the numbers in to English words in excel 2007.(Ex: 11- One One, 20- Two Zero, 21-Two Zero like that)
    Please send me the solution for above querry,

    it is very much urgent..
    thank you very much..

  30. i want number to ward in rupees and due to this formula it comes into dollars, than what's the step for it..............

  31. please suggest me how to use spellnumber in excel ,i fallowed your steps as u say ,the results came" #name?,",like that,so plz show me right usage .....

  32. Dear Stephen,

    please send me excel sheet for converting same Pls

    thanks

  33. Dear Kindly let me know in dirham how to change spellnum in dirham

  34. I have a lot of city name and code

    Example
    i type a code 001 At Cell (A1) - spell Number will show (american) at the another sheet
    i type a code 002 At Cell (A1) Also - spell Number will show (african) at the another sheet and so on... I have a lot of city name to make it, please help me

    Thanks

  35. Dear Stephen,
    please send me excel sheet for
    converting same

  36. Sir,

    Please send details of excel sheet in permanent add for automatically spellnumber on MS excel- 2007.

    Thanking you

  37. Thank You So Much :)

  38. Hi,
    Can i have a copy of the formula in excel for the converted value, please ?

  39. This one how do the amount currency change?

  40. Please send me same excel sheet with formula,

  41. Beautiful!!!!

    Thank you for posting and making it so easy to implement. Really helped out in a crunch.

  42. Sir, How can i convert dollar into Rupees and cent Into paisa in SpellNumber. I mean i want to change numeric value into words in pakistani currency. Kindly guide.
    Your early response must be appreciated

    1. Umer its very simple, after copying the above formula into module press CTRL+H and replace the word Dollar with Rupee and Cent with Paisa and then safe the module.

  43. How can I change Dollars to US Dollars?

  44. could you please send me the copy of these excel sheet please ,as soon as possible , please please

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

  46. 48,683.00

  47. =SpellNumber(...)

  48. Dear Friends,

    Requesting you, kindly share the any worked excel sheet to me.
    i need the how to change the number to words, becoz i want to create the new manual invoice sheet. any time i want to change the value in number and words also.

    kindly do needful

  49. Vinayak There is A Bug in the Module you have pasted request you to pls send me the Revised VBA if possible

    Thanks...

  50. Great thanks. This is awesome.

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 :)