Show or hide the thousands separator

Applies To
Excel for Microsoft 365 Excel 2024 Excel 2021
  1. Select the cell contents in Excel that you want to format.

  2. On the Home tab, select the Dialog Box Launcher next to Number.

    Screenshot that shows the Dialog Box Launcher in Number group.

  3. On the Number tab, in the Category list, select Number.

  4. To display or hide the thousands separator, select or clear the Use 1000 Separator (,) check box.

Tip

To quickly display the thousands separator, select Comma Style. in the Number group on the Home tab.

Note

By default, Excel uses the comma as the system separator for thousands. However, in Excel, you can specify a different system separator. For more information, see Change the character used to separate thousands or decimals.