How to insert comma in excel for multiple rows

Changing the comma style in Excel is a straightforward task that makes number formatting more user-friendly. Whether you want to use commas to separate thousands or switch to a different style, follow these steps to get it done.

How to Change Comma Style in Excel

This guide will walk you through the process of changing the comma style in Excel step by step to ensure your numbers are formatted exactly how you want them.

Step 1: Open Your Excel Workbook

First, open the Excel workbook where you want to change the comma style.

Opening the workbook will allow you to access the specific worksheets and cells you need to modify.

Make sure you have the necessary permissions to edit the file.

Step 2: Select the Cells You Want to Format

Next, click and drag to select the cells containing the numbers you wish to reformat.

Selecting the right cells ensures that only the chosen data will be affected by the changes, leaving the rest of your workbook untouched.

Step 3: Click on the ‘Home’ Tab

Go to the ‘Home’ tab located at the top of your Excel window.

The R

how to use indian comma separator in excel

how to use comma separated values in excel