Display or hide the thousands separator in a number
Add or remove a thousands separator
- Select the cells you want to format.
- On the Format menu, click Cells, and then click the Number tab.
- In the Category list, click Number.
- Select or clear the Use 1000 separator (,) check box.
Add the default thousands separator
-
Select the cells you want to format.
-
Click Comma Style
on the Formatting
toolbar.