Display or hide the thousands separator in a number

Microsoft Office Excel 2003

Show All Show All

Display or hide the thousands separator in a number

Add or remove a thousands separator

  1. Select the cells you want to format.
  2. On the Format menu, click Cells, and then click the Number tab.
  3. In the Category list, click Number.
  4. Select or clear the Use 1000 separator (,) check box.

Add the default thousands separator

  1. Select the cells you want to format.

  2. Click Comma Style Button image on the Formatting toolbar.