MS Excel currency converter - Number to words Latest version

-
MS Excel currency converter 3.0 has been updated with bug fixes.

This is the new version of my amazing currency converter VBA utility for MS Excel. The macro will convert the currency number which is in number to text. For example, Rs. 14,250 is a common standard to represent the money of Indian Rupees Fourteen Thousand, Two Hundred and Fifty. This VBA code takes the input as 14250 and prints as 'Fourteen Thousand, Two Hundred and Fifty'.

It can be used in writing cheques, generating financial reports, MIS reports, and other accounting purposes. If you are familiar with accounting software such as Tally, you will know that the current number is converted into text. But this feature is not available in MS Excel.

The earlier version had few bugs which were reported by the users. I have fixed them in this version. 

Below is the list of bugs fixed

1. For 1000 and 100000 it was resulting in a null string. Now it has been fixed.

You can download the VBA module here. After downloading go to your Excel VBA editor. Then, go to Insert Menu, Insert Module. Paste the VBA code just downloaded. Go back to your excel spreadsheet by pressing ALT+F11. Start using the new function.

Download

Download here the Complete Excel.

Download
Please let me know if you have any specific questions to currency converter or any generic VBA code questions. If you are looking for any new features in MS Excel or MS Word, I will try to implement them in using the VBA code.  

Comments

  1. UnknownMay 20, 2014 at 9:05 PM

    I have installed this module ... In my case for when i enter "2000" it shows as "twenty two thousand"
    Thanks for your help

    ReplyDelete
    Replies
    1. Krishna SNovember 15, 2014 at 12:25 PM

      I could not reproduce this error. Please re do the steps again.
      I have release a latest version 4.0 with some bug fixes. Take look at it once

      http://krishnasr.blogspot.in/2014/11/latest-version-of-latest-version-4.html

      Delete
  2. ArtiOctober 30, 2014 at 5:18 PM

    Krishna,your code gives errors for numbers greater >2000 & nos in lacs. Just as Murthy mentioned the code shows "twenty two thousand" for 2000 & "twenty two lacs" for 2,00,000.
    Please help to debug this error.

    ReplyDelete
    Replies
    1. Krishna SNovember 15, 2014 at 12:27 PM

      Hello Arti,

      Thanks for notifying me the issue with 2,00,000. I Have fixed it in the latest version

      http://krishnasr.blogspot.in/2014/11/latest-version-of-latest-version-4.html

      Your feedback will encourage me

      Delete
  3. AnonymousApril 26, 2015 at 2:02 PM

    Word Rupees should be before not after.
    For Ex. Rupees One Lac Fifteen Thousand Two Hundreds Fourty Five & Twenty Five Paisa.

    ReplyDelete
  4. AnonymousJune 11, 2016 at 12:36 PM

    How to use the function in excel file

    ReplyDelete
  5. juanjuergensMay 22, 2017 at 9:01 PM

    Someone Sometimes with visits your blog regularly and recommended it in my experience to read as well. The way of writing is excellent and also the content is top-notch. Thanks for that insight you provide the readers!
    excel vba courses london

    ReplyDelete
  6. UnknownAugust 12, 2017 at 12:07 PM

    where i find this Add In to convert the currency?

    ReplyDelete
  7. AnonymousDecember 13, 2017 at 10:36 PM

    Like your work..very nice keep doing good work.

    Compress JPG online
    Compress PNG Online
    Online JPEG Compressor Tool
    convert png to jpg without losing quality
    Online Image Optimizer
    JPG Size Reducer
    Photo Compressor

    ReplyDelete
  8. Jayden RichFebruary 6, 2018 at 11:15 AM

    I enjoyed this and I will be back for more. Foreign Currency Exchange

    ReplyDelete
  9. AnonymousAugust 4, 2024 at 10:00 AM


    Power BI Advanced Training London UK, Power BI Advanced course London UK. We provide all Microsoft Certification in classroom, live online training with flexibility of weekend and evening.

    https://www.londonittraining.co.uk/power-bi-advanced-training-certification-courses-london-online-uk/

    ReplyDelete
  10. Ella BAugust 12, 2024 at 2:05 PM

    Hi thankks for sharing this

    ReplyDelete

Post a Comment

Popular posts from this blog

Connecting Bluetooth headset with laptop - Bluetooth A2DP

-
A normal phone Bluetooth headset can be easily connected to a laptop and it can be used as earphones or headphones while using skype, gtalk, WhatsApp, or any other voice chat services or of course to listen to your favorite music. All you need to do is a Bluetooth device and the Bluetooth driver with the A2DP(Advanced Audio Distribution Profile) profile. Amazon Web Services Quiz: Essential AWS Concepts Here is the detailed procedure the setup Bluetooth device with your laptop. Download the A2DP Bluetooth driver from the link provided below. Extract the zip file 'Bluetooth A2DP Driver For Windows.zip'. Go inside the folder 'Bluetooth A2DP Driver For Windows', double-click on the installer file 'anyone-Bluetooth-usb2x0-WindowsXP-v2-1-0-4.exe'. Follow the onscreen instruction to complete the installation.  Once the A2DP driver is installed successfully, Switch on the Bluetooth in the Laptop and Headset. Look for the Bluetooth device the list of ...
Read more

Why some mobile phones does not support screen mirroring?

-
Image
On my Youtube channel, I have posted a video that shows how to mirror your mobile screen onto LED or LCD TV which is equipped with Wi-Fi and Miracast. To clarify what is Miracast, it is a hardware device built into your TV. If your TV is equipped with Miracast, then you don't have to use any additional dongles like Google ChromeCast to cast your mobile screen onto the TV. Please note that the Miracast feature and Google Chromecast may work differently. I got lots of comments asking questions like whether the TV is smart, whether the TV is used as a monitor with a CPU, is there any dongle connected to the TV, whether it requires internet, etc.  To clarify all these questions, it is a basic LED TV with Wi-FI and Miracst enabled. No internet, no dongle connected and it is not a smart TV. The most important question I am trying to clarify here is why some mobile phones do not have mirroring options. First, you need to understand that screen mirroring works on a Wi-Fi network...
Read more

Convert currency to word in excel

-
There are plenty of online resources to convert Numeric currencies to Text- from $200 to Dollar Two Hundred. But this is applicable only ###,###,### (comma at every third number)format.  This is not suitable for India numbering system, because we follow ##,##,###(....22,22,222) format. So I have create a excel function to over come this. You can use this function to to convert number up to 10,00,00,000(ten crores). How to do it Open Excel Press Alt + F11 From Menu Bar  Insert Module Copy paste the This Module there. Exit from VBA window by pressing Alt + F11 again In excel sheet, Insert Function, Under user defined find   ConvertCurrencyToEnglish  select it and provide the number as a parameter thats all you are done ---------------------------------------------------------------------- Code (alternatively you can download the module from here ) ---------------------------------------------------------------------- ' ...
Read more