Format numbers in Indian comma style with negatives in parantheses

I have found the below mentioned formula to custom format numbers in Indian comma style of crore, lakhs, thousands. The formula does not provide desired results for negatives. Also I am in need of mentioning the negatives in paranthesis i.e negative no. of 1 crore as (1,00,00,000.00). Please give the solution to the above.

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

Please provide detailed solution since I have only basic knowledge in excel and have not dealt with macros programming.

This page:
http://exertia.wordpress.com/2006/04...ores-in-excel/
may be helpful
Regards
Mike

Originally Posted by Mikeopolo

This page:
http://exertia.wordpress.com/2006/04...ores-in-excel/
may be helpful
Regards
Mike

Thanks for the Good link. But what stated in it as easy way by changing the regional settings doesn't work.

regards
Sripathy

I could not verify the results of the macro altered due to my exams. Today I have verified it but still need the rectification for

If any blank cell is in the range and value is entered in that after applying macro to it when it was a blank cell it shows the minus sign before the number entered. (example if number 2 is entered it shows as " - 2"). Please rectify it and post it.

Question: would a modified version of the Macro above also provide a viable solution to this problem:

I have a large table of values denominated in Euros. For some reason, Germans switch commas and decimal points (eg 700.000,00).

As a result, my American excel program on my American machine does not recognize the numbers properly....

....Is there a way to change the symbols without reconfiguring the settings on my entire system each time I want to do this?

http://www.excelforum.com/excel-gene...minations.html

If so, I'll work on a way to combine the two to create a VBA script that can be a sort of "Rosetta Stone" for different number systems. My company could sure make use of such a thing.

great, this works!

How do I add the Indian Rupee symbol ₹ to this VB script?

Originally Posted by shg

Maybe like this:

Please Login or Register  to view this content.

Adding a Macro to a Code Module
1. Copy the code from the post
2. Press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window that opens
5. Close the VBE to return to Excel

Select the cells you want to apply the formatting to, and then run macro ApplyLakh (do Alt+F8 to bring up the macro dialog, select ApplyLakh, Run)