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

Java/Android Currency (Money) Field Validation

Hi everyone,

Today, I have come across one situation where money(currency) field has to be validated. According to Indian currency, we will consider 2 digits after period(.)

When I want to validate the particular field, I have tried with substring() and indexOf() methods. But I am not getting the expected result. I want to have the output ending with .##, So, I have come to know about NumberFormat class from java.text package.

Here goes sample code with output:
Input: 234 / 234.232 / 234.3
Output: 234.0 / 234.23 / 234.3

NumberFormat nf = new DecimalFormat(".##");
System.out.println("Input: "+234+"Output: "+nf.format(234));

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