Digit Grouping in Excel
We need to have an option to change digit grouping in excel for a particular workbook. This is very helpful when we are working in multiple currencies. If we are using US Dollars, we should be able to have digit grouping of 3 digits, i.e. millions, e.g. 123,456,789.00. If we are using Indian Rupees, we should be able to have digit grouping of millions or crores, as we wish, e.g. 123,456,789.00 or 12,34,56,789.00. Currently the only way to make the change of digit grouping is to change digit grouping through Region settings in Windows.