Currency Separator

[DrMurali]

Can this separator be only for thousands or can it be changed as it is done for Indian currency? For Indian currency, the numbers go in thousands up to 100,000 which is called one lakh. For example, 150,000 rupees becomes 1.5 lakh rupees, written as ₹1,50,000 or INR 1,50,000. Then 1,00,00,000 (one hundred lakhs) is one crore.  It is written as 1,00,00,000 with the local 2,2,3 style of digit group separators. Can this type of separators be created in Excel?

[#2]

@DrMurali

If you are on Windows, you can set the digit grouping to 12,3456,789:

Excel will then use it.

If you use standard digit grouping 123,456,789, it will be very complicated to apply lakh/crore formatting.

[#3]

Thanks for sharing this method! However, looks like it will be universally applied for all Excel files. That would be a problem for currencies that use the thousands format throughout - thousands, millions, billions, etc. So, I got to think about this.

[#4]

@DrMurali 

You might request digit grouping to be applied at the workbook or worksheet level, or to be set in a custom format. In Excel, select Help > Feedback.