You can apply a number, accounting, or currency format to some cells in excel. In excel, how can i format a column to display commas after every three digits for millions and after every two digits for lakhs in the same sheet? There is a better and permanent solution (for indian users):
PPT Allied Waste Services Residential Trash & Recycling Holiday
Getting indian notation in excel is not all that tricky if you know where to adjust the settings. In this tutorial, you will learn different ways to apply comma style in excel by using four easy to follow methods. In this post we explain 2 options in which you can do this.
This article demonstrate to you to change the comma in excel to indian style using format cells option and set regional format.
Region setting > additional settings>change the digit grouping to the format you want. It is based on windows settings. This article shows 4 ways how to change comma style in excel using home tab, format cells option, keyboard shortcut and cell styles option. Then you can see the indian comma format and indian.
The only way i can replicate your problem is by using the custom format i gave you in a cell, then copying the output to another cell as a value, but then i go to number format and. I.e comma separator for custom currency (indian rupee). You'd need to apply the same setting for currency as. In this post i will show you how to display us dollar format to indian currency format in microsoft excel.
