Forum Discussion
DrMurali
Apr 28, 2024Copper Contributor
Currency Separator
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? |
3 Replies
Sort By
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.
- DrMuraliCopper ContributorThanks 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.
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.