How to modify MS excel "1000" separator for Indian counting system?

Question

"1000" Separators upto 100 thousand(not including) present no problem as they are same as the rest of the world but after that we need 100 separators(100 thousands make one lakh, 100 lakhs make one crore).
How to make excel follow this number format?

Answer 1

Right-click on the cells which you want to display as lakhs, and click on Format Cells, then go to the Custom category and enter the below formats:
For Lakhs (+ve and -ve):

With 2 decimals:

[>99999]##\,##\,##0.00;[<-99999.99]-##\,##\,##0.00;##,##0.00

Without decimals:

[>99999]##\,##\,##0;[<-99999.99]-##\,##\,##0;##,##0

For Lakhs and crores (+ve)

[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

For Lakhs and crores (-ve)

[<-9999999](##\,##\,##\,##0.00);[<-99999](##\,##\,##0.00);##,##0.00

There is an easier way to change the global settings from Settings > Control Panel > Regional Settings > Numbers, but that will affect all your Excel sheets and the change will be visible only on your system and not on your files which you send to others.

Answer 2

Go To Format after right clicking the cell and select Currency mode INR Rupees
Then select Number mode and select Use 1000 separator with 2 decimal points and apply format to all cells in the row.
Repeat procedure for columns again

Note: You must be using MS Office 2000 or XP. Excel 97 and 2003 do not suppot the above feature

Answer 3

call up microsoft in there india office and speak to there technical support staff, and if they don't help, make a plug-in for it and sell it to them