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

Similar to how India uses the 2, 2, 3 system of number value accounting for lakhs, the U.S. uses 3, 3, 3 for millions. We will show you how to change the comma separator in Excel to the Indian style. Let’s suppose we have a sample data set for profits.

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

Step 1 – Creating the Data Set with Proper Parameters

Here is our sample data set, where we’ve manually put the values. You will see the profit values are in the general usual format in US dollars in millions. We want to change this format to the Indian style in lakhs.

Creating Data Set with Proper Parameters

Step 2 – Using the Format Cells Option

  • Go to the Home tab.
  • Click the arrow on the drop-down that shows the Number group.
  • Select the More Number Formats… option.

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

  • The Format Cells box will open.
  • Go to the Currency option.
  • Keep decimal places at 0 and select the English (India) symbol.
  • Click OK.

  • This changes the value to represent rupees.

  • Click on the Start button.

  • Type Set Regional Format and click on the first result.

  • Change the Regional Format to English (India).

Step 3 – Showing Final Result

  • Here’s how the table will be converted after setting the regional style to India.

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 practice.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
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

  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