Convert Number to Words in Indian Currency

It would be an understatement to say that I totally adore MS Office, Excel in particular. It simplifies my life at office, and VBA Macros are a huge blessing!

I was looking to convert numbers to words in the Indian currency system and the first hit I got was this particular link from MS Office Support (now you know why I love MS Office!). However, this is suited more to the western number system, and I had to modify it a little to get it to work for me.

You can download the add-in from this link –> SpellNumber.

To install (in Excel 2003):

  1. Save the xla file in the folder below: C:\Documents and Settings\Your User Name\Application Data\Microsoft\AddIns
  2. Start Excel -> Open a new file
  3. Go to Tools->Add-Ins->Browse
  4. Select SpellNumber.xla and hit Ok
  5. In the Add-Ins available dialog box, select (tick checkbox) the Spellnumber Add-In
  6. For using: In the cell, use the command =SpellNumber(cell reference)

Do let me know if this helpful!

PS: Updated to remove a major bug.

Thursday Afternoon WTF

I hate Microsoft for Windows. So buggy and sometimes so arrogant. But I do respect them a lot for MS Office. This is one product that kicks ass and Excel VBA programming saves us so much time and effort that I have come to love it.

But then this happens and I start doubting it.


How am I supposed to react to this shit?? Duuh??