Cell properties: Format value

The Format Value tab controls value formats for the selected cells. You can select formats for numbers, dates, time, or currencies, and you can adjust the number of decimal digits that are displayed.

To change value formats for selected cells in a pivot table:

  1. Activate the table.
  2. Select the cells that you want to modify.
  3. From the Format menu or the pop-up menu choose, Cell Properties.
  4. Click the Format Value tab.

Note: The list of Currency formats contains Dollar format (numbers with a leading dollar sign) and five custom currency formats. By default, all custom currency formats are set to the default number format, which contains no currency or other custom symbols. Use Edit>Options>Currency to define custom currency formats.