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 GISTConvertCurrencyToEnglish.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:
Post a Comment