Format currency in Indian System in Excel

Problem: The Indian system uses a comma separation convention which is different from the typical Western convention

e.g. Rupees 10 million (10,000,000) is conventionally written as Rs. 1,00,00,000

Why? Because it is read as Rs. One crore.

Excel formatting options:

Right click, choose custom formatting, enter the following in the formula

For Rupees with Paise--

[>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. "##\,##\,##0.00;"Rs. "##,##0.00

For Rupees without Paise ---

[>9999999]"Rs. "##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs. "##,##0

Source: http://www.tech-archive.net/Archive/Excel/microsoft.public.excel.misc/2006-01/msg02617.html