Monday, February 13, 2012

Excel Addins : Spell Currency Excel Addin

I am sharing Excel Addin for converting Numbers to Words. I keep getting mails / comments where people are not able to install the VBA code shared in my earlier post

Excel Functions : Convert Numbers to Words.

Photobucket



This Addin will make it easier to use. This Addin can be installed on any computer having Excel 2007 and above versions. Once Installed you can use SpellCurr() formula in any excel file on that computer.

You need to download and open Addin file on your machine. This will install the Addin automatically to your machine.

However if you send file to another person you need to send the Addin along and ask that person to install it on his/her machine so that your formula can work there.


Download SpellCurr Excel Addin for converting numbers to words - Excel 2007 Version



Download SpellCurr Excel Addin for converting numbers to words - Excel 2003 Version



Numbers to Words , Convert Number to Words , Convert Number to Word , Number to Words , Number to Word , Number to Text , Number in Words , Number to Letters , Convert Number to Text , VBA Number to Text , Number to Text Function , Numeric to Text

Posted by Yogesh Gupta at 10:51 PM
Labels: , ,
Reactions: 

68 comments:

  1. Add in Good, but issue I am facing, that I can not use this Add in Excel 2007 Version.
    Pls advise

    ReplyDelete
    Replies

    1. @Diwakar Pls check that you have enabled macros on your machine and you have access rights to use VBA on your machine.

      Delete

    2. Thanks. Also this Ready Made utility Convert number to indian rupees.
      http://www.soft.nkworld.in/2012/08/convert-number-to-english-words-in.html

      Delete

  2. The above spell currency is brilliant. But is it possible to insert the new "Rupee" sign in this formula. pls suggest.

    ReplyDelete
    Replies

    1. @Mehuls - Inserting a Rupee sign is not a Excel Function. For this you need to install Font on your machine and then use the new Rupee Symbol on that machine.

      Delete

  3. Thats great Mr. Gupts but i want readymade formula to convert into million format. please send me a link. Thanks in advance

    ReplyDelete

  4. This is Ganga unfortunately downloaded exel file deleted,while i am open any exel document it show error and it should always click OK option to proceed futher proced of work so pls solve my problem.

    ReplyDelete

  5. well sir this formula reads only hundreds in figures so if the amount is above lakh then it does not spell in lakh

    ReplyDelete

  6. Dear Mr Gupta, thanks for addin but when I type =Spellcurr(100000), it shows One Hundred Thousand! We need to make it One Lac or One Lakh! How to do?

    ReplyDelete
    Replies

    1. Dear Bharat,
      I also facing same problem with =spellcurr(100000) and above...
      mr. yogesh please suggest...for the same.

      Delete

    2. SpellCurr works on thousands and millions format. If you are looking for Indian format of Lakhs and crores please download another macro from download section of the blog.

      Delete

    3. Can u plz send me blog for Indian Format of Lakhs and crores??

      Delete

    4. pls i also want indian format for lakhs and crores

      Delete

  7. Dear Mr.Yogesh Guptha,Thanks for your addins for calculating age. I need to calculate the age of a person on a particular date.( eg: age as on 31.03.2012). How can I do this?

    ReplyDelete
    Replies

    1. Pls replace TODAY() in the age formula with reference to cell containing date 31.03.2012

      Delete

  8. I installed your spell currency add-in and it worked like a charm. Very useful.
    The users should take a careful look at your recorded video to see the coding for currencies other than the rupee.
    Thanks.

    ReplyDelete
    Replies

    1. Thanks. Also this Ready Made utility Convert number to indian rupees.
      http://www.soft.nkworld.in/2012/08/convert-number-to-english-words-in.html

      Delete

  9. I also facing same problem with =spellcurr(100000) and above...
    mr. yogesh please suggest...for the same.

    ReplyDelete

  10. Im trying to write a small vba routine to have excel 2007 connect my access data file. I dont understand the "string" syntax. Can anyone help?

    ReplyDelete

  11. sir, plz give the ppassword of addin spellcurcency excel 2007

    ReplyDelete
    Replies

    1. Why do you need the password.. If you just need the code for spellcurr then it is already available at the blog at http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html

      Delete

  12. Yogesh Sir,
    This is very cool stuff and very much useful for me. whether it can read in lakhs, for E.g 2050500 i want spell the amount like this "Twenty lakhs fifty thousand and five hundred only". thank you

    ReplyDelete

  13. great. is it possible to get this without currency code (like rs or dollar)

    ReplyDelete

  14. Hi,

    You have wonderful resource for excel in your site.

    Can you help with parsing addresses from different countries into street, city, state, country and zipcode? Note that the addresses are not in any fixed format and there is no standard delimiter.

    ReplyDelete

  15. Good effort yogesg g. i have a invoice template which i use to make invoices. i need a macro or code which automatically print 3 copies + auto save as a copy of invoice with specific cell value as name in specific folder.

    can u help me plz....

    waiting for ur kind reply......


    Regards,

    Waheed

    ReplyDelete

  16. Add ins is fine and user friendly but how can I convert the currency into Bangladeshi Taka and Paisa.

    ReplyDelete

  17. Dear Mr Yogesh
    First of all very nice script, but I am facing a problem here. I work in Oman and making a invoice for my company so I use your script. here in Oman Currency is OMANI RIYAL (OMR) and lower multiple is BAISA. Now the problem is that BAISA is having 1000 denomination (means 1000 Baisa is equal to 1 riyal) and when I am placing your script its just taking upto 2 decimal places and also Currency name as Paisa. can you pls tell me how to edit this or give me edited script for the same.
    Thnx
    Kishor

    ReplyDelete

  18. Thank you for this. I am using Thai Baht and "Baht" and "Satang" never use an "s" to make them plural. Is there a way to remove this s from the text?

    ReplyDelete
    Replies

    1. Dear Mr Yogesh

      I have the same issue so it could be very nice if you could address this problem.
      In Thai currency there are no "s" at the end. 1 Baht, 2 Baht etc.
      How do we fix this?

      Thanks
      Myke

      Delete

  19. Thanks
    can you help how to convert Omani Rials, as 1 Omani Rial contains 1000 Baisa not like another currencies eg 1 Rupee contains 100 Paisa......Like for One Rial Seven Hundred Baisa its showing only seventy baisa

    ReplyDelete
    Replies

    1. You need to replace the following lines of the code

      Paisa = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _
      "00", 2))

      With

      Paisa = GetHundreds(Left(Mid(MyNumber, DecimalPlace + 1) & _
      "000", 3))

      After this change in the code, you will be able to convert your number to 3 decimals of baisa.

      Delete

  20. Thank You Very Much...It was very helpful...

    ReplyDelete

  21. This comment has been removed by the author.

    ReplyDelete

  22. Hi I want to first thank you for the brilliant spellindian formula.
    I want to know if there is anyway of avoiding paise in the words? I have rounded off in the amount but in the words the paise still comes.
    Thanks
    Anuj

    ReplyDelete

  23. Hi Yogesh Sir,

    I am glad to find your site while looking for SpellNumber Function in excel.

    I am using Excel 2003. I am working in Namibia, I am dealing with different vendor, which are in different currencies, like US$, Rands, N$, GBP, etc. I did install your excel addin, but still not getting what I am looking for?

    Is there any vba code/function which we can incorporate with Spellnumber function?

    Thanking you in advance.

    ReplyDelete

  24. Hello Mr. Yogesh,
    First of all thank you as i found the conversion of numbers into words. I then downloaded excel sheet comprising macro (YOGI ANAND's) for the same purpose in Indian style. please convey me regarding convertion of it into add-ins as you have created so that I can escape form repitative procedure of pasting the same macro number of times in every new excel sheet.

    ReplyDelete

  25. Sir
    I want to convert the following three things of excel 2007 in words
    1. Numbers to be converted into hindi words.(Indian formet)
    2 Date of bith to be converted in Hindi and English words
    3 Numbers converted in English words(Indian formet)
    If possible please sent this excel file to my maile guide me.
    Mail-pratibhajames@rediffmail.com
    jamescheriandpr@yahoo.com

    ReplyDelete

  26. Dear Sir,

    I want to delete this addin, please advise how to do that.
    Thanks

    ReplyDelete
    Replies

    1. You can uninstall this by following the steps mentioned at following link

      http://office.microsoft.com/en-us/excel-help/add-or-remove-add-ins-HP010342658.aspx#BMexceladdin

      Regards

      Delete

  27. Dear Yogesh ji,

    Thnx for the SpellCur formula.

    I request a slight modification as per my requirement.

    I need to convert figure into text without currency name i.e.

    (a) 1234 - One Thousand Three Hundred Thirty Four only
    (b) 1234 - One Thousand Three Hundred Thirty Four

    Please note that each letter is Capitalized

    I wud be highly oblidged if u provide me the above two requirements in excel file.

    Thnx !

    ReplyDelete
    Replies

    1. Dear Dhawal

      Kindly use following formula along with spellcurr addin

      =RIGHT(spellcurr(A1),LEN(spellcurr(A1))-7)

      This assumes that your input number is at cell A1, you will need to change as per your data

      Thanks

      Delete

    2. I have an alternate function that has the option to work the way you want (and which has an absolutely huge range of operation) at my mini-blog site here...

      http://www.excelfox.com/forum/f22/yet-another-number-words-function-sorry-us-style-only-364/

      Delete

    3. Dear Yogesh Sir,

      Thnx ! but can it be a little simpler like say =CONV(A1)

      Regards
      Dhawal

      Delete

  28. Thank you Very much sir
    you removed a whole load of typing work from my head. this now saves me a lot of time.

    Regards

    ReplyDelete

  31. thanks for this code, but i hv one problem after saving this code in module when i click save it says that
    'the following features cannot be saved in macro-free workbooks:
    vb project
    to save a file with these features, click no, and then choose a macro-enabled file type in the file type list.
    to continue saving as a macro-free workbook, click yes
    yes no help
    i hv selected yes and no also but i hve to copy that code again

    ReplyDelete
    Replies

    1. when i reopen file it is not asking for enable macros

      Delete

    2. i think xlsx and xlsm is not supported, its only ask 'enable macro' for xls format.. is it right ?

      Delete

    3. when i protect file with password after that its not asking for enable macros

      Delete

  32. Thanx for Spell indian would u help me to find duplicate values in coulmn without deleting other duplicate values

    ReplyDelete

  33. 99,99,99,99,99,999.99 = Takas Nine Lac Ninety Nine Thousand Nine Hundred Ninety Nine Crore Ninety Nine Lac Ninety Nine Thousand Nine Hundred Ninety Nine and Ninety Nine Paisas Only``````
    How will solve it

    ReplyDelete

  34. I would be most grateful if you could advise me of how to remove the plural from the pence, as this is incorrect in the English language.

    Many thanks

    ReplyDelete

  35. Hello Sir, I received many datas from many units sum unit rounddown with 2 place of decimal sum units roundup with 2 place of deci would u plz help me to use rounddown & up function in same cell with 2 place of decimals
    waiting 4 urs valuable reply

    ReplyDelete

  36. how to convert text to RMB (Chinese Yuan)?

    ReplyDelete

  37. hello, this is helpful but still have problems while converting millions and crores data

    ReplyDelete

  38. Hi, is there a spellcurr version for microsoft excel 2013? Thanks.

    ReplyDelete

  39. Thannx a lot Bossssssssssssssssssss...................

    ReplyDelete

  40. My name is Naomi Struttgard, I am here to testify to the good work of the Dr. CHECK. 4 years ago, my husband left home, he never returned, no phone calls, no letters, no emails, no sign of him anywhere. my daughter got sick with multiple sclerosis, things were so tough for me. I had lost hope, 2 years ago, i met a psychic, he said he would help me,i paid over $6800 and still nothing happened, i lost hope completely, my daughter's situation got worse each day.last month, i saw a posting concerning the good works of the wole professionals, i gave them a try...i paid about $2000, for all three spells (Bring Lover back, Healing spell and Career spells). In a matter of weeks, my husband called me and told me he was sorry and that he wants to come back to me and that he would explain everything when he comes back, three days later, i got a new job with a loan and finance company, right now, my daughter's condition is getting better each day and i trust she would be well in a matter of days.I want to thank templeoflove1@gmail.com for their efforts and for bringing my life back to normal and so close to perfection.My name is Naomi Struttgard, i live in Australia http://templeoflove1.webs.com/

    ReplyDelete

  41. Sir,

    I hv downloaded this but unable to use.. pl suggest where to keep ( Folder specific) this add in file

    ReplyDelete

  42. This is very cool stuff and very much useful for me. whether it can read in lakhs, for E.g 2050500 i want spell the amount like this "Twenty lakhs fifty thousand and five hundred only". thank you

    ReplyDelete

  43. Dear Mr.Yogesh
    Thank you very much for the spell curr addin. It would be of great help if an addin could be developed for spellindian as am not able to find the same in your blog.The rupees comes in millions wherein I require the same in lakhs. Pls help.

    ReplyDelete

  44. Dear Mr.Yogesh

    Have downloaded the xls file developed by Mr.Yogesh Anand converting into Indian currency but how do I incorporate the same into my xls file. Pls guide me.Thanks in advance

    ReplyDelete

  45. Dear Mr.Yogesh


    Thanx for Spell indian would u help me to find duplicate values in coulmn without deleting other duplicate values

    ReplyDelete

  46. Hello Mr. Yogesh,

    Thanks for kind help, this article is very useful, but when i used this formula for Kuwait Dinar, the Fills value is reading only for two digits.

    Eg: Five Kuwait Dinars and Fills Fifteen Only (5.150) where as it should be Hundred Fifty Fills, kindly suggest the solution for this.

    ReplyDelete

  47. HI Yogesh,
    i need a support in your curr converter. the problem is in six digits its convert Wrong conversion.
    EG. 100000 Rupees One Hundred Thousand Only
    " Can we convert in One lakhs "

    ReplyDelete

Subscribe to: Post Comments (Atom)