March 31, 2017

Change currency (Rupees and Euros) to English text in Microsoft Excel

Hi Friends,

Today I'll discussing about converting currency (Rupees and Euros) to textual representation which I have found by googling and updated to cover 2 currencies.

Source

The VBA Macro code is available on my public GIST
ConvertCurrencyToEnglish.txt

Usage


  • Add this in your excel module using developer options
  • Two functions
  • ConvertRupeesToEnglish - Which converts numeric data to rupees with pre-pending "Rupees " and appending " Only"
  • ConvertEurosToEnglish - Which converts numeric data to rupees with pre-pending "Euros " and appending " Only"
  • Note: If number has precisioin, it will add "Paise" and "Cent" to respective currency.
Please send your review and feedback to psrdotcom@gmail.com

No comments:

Featured Post

Java Introdcution

Please send your review and feedback to psrdotcom@gmail.com