How to Change Comma in Excel to Indian Style (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

The Excel comma style, also known as the thousand separator format, converts huge number values into thousands, hundred thousand, millions, and other units of measurement by inserting commas as separators. This article will demonstrate to you how to change comma in Microsoft Excel to Indian style.


How to Change Comma in Excel to Indian Style: Easy Steps

Depending on the area and the system’s default currency format used, the comma style separator may display numerical values separated into thousands, lakhs or in million forms; however, you can alter it from lakhs to million and vice versa. Similar to how India uses a system of number value accounting in lakhs and the USA uses millions. Here, we will show you the step-by-step procedures to change the comma in Excel to Indian style. Let’s suppose we have a sample data set.

Step-by-Step Procedures to Change Comma in Excel to Indian Style


Step 1: Creating Data Set with Proper Parameters

  • Here is our sample data set.
  • Besides, you will see the profit values are in the general usual format in US dollars in millions.
  • Therefore, we want to change this format to the Indian style in lakhs.

Creating Data Set with Proper Parameters


Step 2: Using Format Cells Option

The numbers are given decimal values when the user uses the comma format. In summary, it functions similarly to an accounting system format but does not append a currency sign to the number as an accounting system format does.

  • Firstly, go to the Home tab.
  • Then, click on the arrow at the position 2 icon from the Number group.
  • After that, select the More Number Formats… option.

Using Format Cells Option to Change Comma in Excel to Indian Style

  • Here, the Format Cells box will open.
  • Besides, go to the Currency option.
  • Then, keep the zero decimal point and select the English (India) symbol.
  • After that, click OK.

  • Therefore, you will see in the below image that represents the value of profits for all the products in million, but we want to change this in Indian style in lakh.

  • So, click on the Start button in the below right corner at position 1.

  • Then, type here Set Regional Format and click on this.

  • After that, change the Regional Format to English (India).


Step 3: Showing Final Result

  • Finally, you will see in the below image which shows the change of comma in Excel to Indian style in lakh.

Showing Final Result to Change Comma in Excel to Indian Style

Read More: How to Change Comma Style in Excel


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


Conclusion

In this article, I’ve covered step by step process of how to change comma in Excel to Indian style. I sincerely hope you enjoyed and learned a lot from this article. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles


<< Go Back to How to Add Comma in Excel | Concatenate Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Bishawajit Chakraborty
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

4 Comments
  1. Thank you. It worked. It was such a hassle earlier.

  2. Thank you so much

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo