Show or hide the thousands separator

  1. Select the cells that you want to format.

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

    Dialog Box Launcher in Number group
  3. On the Number tab, in the Category list, click 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, you can click Comma Style Button image 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.

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.