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

92 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
    2. cannot get this 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
  29. 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
  30. Thanx for Spell indian would u help me to find duplicate values in coulmn without deleting other duplicate values

    ReplyDelete
  31. 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
  32. 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
  33. 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
  34. how to convert text to RMB (Chinese Yuan)?

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

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

    ReplyDelete
  37. Thannx a lot Bossssssssssssssssssss...................

    ReplyDelete
  38. This comment has been removed by a blog administrator.

    ReplyDelete
  39. Sir,

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

    ReplyDelete
  40. 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
  41. 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
  42. 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
  43. Dear Mr.Yogesh


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

    ReplyDelete
  44. 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
  45. 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
  46. hi yogesh thanks for your help but when i am trying to converting numbers on another sheets its doesnt work....its only work on your sheets only...is there any other option to save or making sheets.

    ReplyDelete
  47. Yogesh sir, how do I remove the macro? It needs password to open.

    Pls reply.

    ReplyDelete
  48. Dear Yogesh,
    I have 3 sheets, a, b, and c in a excel file. Cell A1 of sheet b contains number 100. Cell A1 of sheet c contains number 200.
    Now in sheet a,
    If I input b in cell A1, formula result of cell A2 should give 100
    If I input c in cell A1, formula result of cell A2 should give 200

    If I manually type =b!A1, or =c!A1 in cell A2, i get the result. I tried =CONCATENATE("=",A1,"!A1") in Cell A2, and typed b in cell A1, I got result =b!A1, instead of 100.
    Can you help me out?

    ReplyDelete
    Replies
    1. Try =INDIRECT(A1&"!A1") instead of =CONCATENATE("=",A1,"!A1")

      Delete
    2. Thanks a lot Yogesh.

      Your help made my life a lot easier.

      I am not a regular visitor to your site. I happened search for converting Rupees in figures to words, and saw your site. I solved my friend's requirement with your spellindian. Then I thought of asking you about my problem which I thought was impossible for last 2 years. After asking you, I almost forgot about it. Today I remembered and checked your site.
      It is working!
      Thanks again

      Delete
    3. Dear Yogesh,

      The query I asked earlier was a simplified one. I tried to incorporate this in my actual excel file, it created a problem. Now I understand that the query I asked was wrong.
      Here comes the actual situation.

      I have data tables in sheets x1, x2, x3, ....
      In my working sheet, in cell B6, I have formula =VLOOKUP($D$26,'x2'!$A$4:$E$8,2)

      I want 2 in x2 to be from cell A6.
      ie., if I type 1 in cell A6, x2 in formula should change to x1, and i get values from sheet x1.

      Is this possible?

      Thanking you in advance..

      Delete
    4. Replace your formula with =VLOOKUP($D$26,INDIRECT("x"&A6&"!$A$4:$E$8"),2)

      Delete
    5. Dear Yogesh,

      Thanks,

      Working in my file perfectly

      Actually my data sheets are H-1.0, H-0.5, H=0.0, H+0.5, H +1.0, H+1.5, H+2.0
      It was not working initially.
      I renamed sheets to H1, H2, .... H7, and used a lookup table to get values 1,2,3... corresponding to -1.0, -0.5, 0, .....

      Thanks again.



      Delete
  49. i have copy the code in VBA module but still spell curr fuction is not shown in exel 2013 in windows 8
    Deepak

    ReplyDelete
  50. Thank you Yogeshji, You are great.

    ReplyDelete
  51. how coould i find rs sign insteed of rupees

    ReplyDelete
  52. how coould i find rs sign insteed of rupees

    ReplyDelete
  53. dear yogesh ji , namaskar.
    i have two excel sheet in first sheet(central ware house stock position) A column (code no)B column stock qty.
    seccond sheet (branch stock position)A column (code no)B column stock qty.
    i have task daily morning i have to compare branch stock position with central warehouse stock position , at present i am printing both sheet and comapare manullay . i want to help from you, how to i know which item is out stock in branch pls provide any formula.
    regards
    harish

    ReplyDelete
  54. This is siva 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
  55. Thanks Ji...Its working fine....Keep on rocking...

    ReplyDelete
  56. yogesh i need this ans in spellcurr, -500 , rupees -five hundred

    ReplyDelete
  57. yogesh please send me new spellcurr -500, rupees: -five hundred only like this

    ReplyDelete
  58. Yogesh, thank you so much for the excel add in you created. How would I delete the words ONLY on the translated amount. Instead of "One thousand dollars only" should state "One thousand dollars"

    ReplyDelete
  59. Dear Mr.Yogesh
    Thank you very much for the spell curr addin. I require same in euro. plz help me

    ReplyDelete
  60. Dear Mr.Yogesh,
    This formula reads only hundreds in figures so if the amount is above lakh then it does not spell in lakh - as per below.

    174,193 Rupees One Hundred Seventy Four Thousand One Hundred Ninety Three Only

    but we need in Indian format.
    174,193 Rupees One Lakh Seventy Four Thousand One Hundred Ninety Three Only

    ReplyDelete
  61. This comment has been removed by the author.

    ReplyDelete
  62. I need to convert rounded off figure. For example, result for 152.56 should be "Rupees One Fifty Three Only" and result for 125.34 should be "Rupees One Twenty Five Only".

    It is very urgent for me. Plz suggest me what to do. Thanks!

    ReplyDelete
  63. Dear Mr.Yogesh,
    This formula reads only hundreds in figures so if the amount is above lakh then it does not spell in lakh - as per below.

    1,00,000 Rupees One Hundred Only

    but we need in Indian format.
    1,00,000 Rupees One Lakh Only
    please salve it!!!!!!

    ReplyDelete