Forum Discussion
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 exampl...
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.
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.