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.
SourceThe VBA Macro code is available on my public GIST
- 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 email@example.com