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.
Bookmarks