How to Change Comma Style in Excel: A Step-by-Step Guide

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 ‘Home’ tab houses most of the essential formatting tools, making it easy to find what you need.

Step 4: Click on the ‘Number Format’ Dropdown

In the ‘Home’ tab, find the ‘Number’ group and click on the small arrow next to the ‘Number Format’ dropdown box.

This dropdown allows you to select from various number formats, including those with different comma styles.

Step 5: Choose the ‘Number’ Option

From the dropdown menu, select the ‘Number’ option.

The ‘Number’ format provides several customizable options, including the use of commas for thousands separators.

Step 6: Customize the Format

After selecting ‘Number,’ click on ‘More Number Formats’ at the bottom of the dropdown menu. In the ‘Format Cells’ window that appears, adjust the settings to your desired comma style.

This step lets you fine-tune the formatting, such as setting the number of decimal places and enabling or disabling the comma separator.

Step 7: Click ‘OK’

Finally, click ‘OK’ to apply the new comma style to your selected cells.

Clicking ‘OK’ finalizes your choices, updating the cell formatting immediately.

Once you complete these steps, your numbers will show the new comma style you’ve chosen, making your data easier to read and interpret.

Tips for Changing Comma Style in Excel

  • Consistency is Key: Ensure you apply the same comma style across similar data sets for a uniform look.
  • Use Shortcuts: You can use the keyboard shortcut Ctrl + 1 to quickly open the ‘Format Cells’ window.
  • Check Regional Settings: Sometimes, Excel follows the regional settings of your computer, affecting comma styles.
  • Preview Changes: Before finalizing, use the ‘Sample’ area in the ‘Format Cells’ window to preview your changes.
  • Undo Mistakes: If you make an error, use Ctrl + Z to undo your most recent changes.

Frequently Asked Questions

How do I remove commas from numbers in Excel?

Select the cells, go to ‘Home’ > ‘Number Format,’ and choose a format that doesn’t include commas.

Can I change the default comma style for all new workbooks?

You can modify the default template, but it’s generally easier to change it for each workbook as needed.

Why don’t my changes appear immediately?

Make sure you selected ‘OK’ to apply the changes. Sometimes, Excel needs a moment to update the view.

What if I only want to change the comma style for specific rows?

Highlight just those rows and follow the same steps. Only the selected rows will be changed.

Can I use Excel’s Find and Replace to change commas?

Find and Replace works for text changes but isn’t recommended for formatting changes like commas in numbers.


  1. Open your Excel workbook.
  2. Select the cells you want to format.
  3. Click on the ‘Home’ tab.
  4. Click on the ‘Number Format’ dropdown.
  5. Choose the ‘Number’ option.
  6. Customize the format.
  7. Click ‘OK.’


Changing the comma style in Excel is a simple yet powerful way to make your data more readable and professional. By following the steps above, you can ensure that your numbers are formatted consistently and clearly, aiding in better data interpretation. Don’t forget to explore the ‘More Number Formats’ for additional customization options. If you’re handling large datasets or frequently sharing your work with others, mastering these formatting tools can make a big difference. Happy formatting!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy