Changing Data Display Formats

Figure 1. Education Level table
Education Level table

You can easily change the display format of data in pivot tables.

  1. If it's not already activated, double-click the Education Level table to activate it.
  2. Click the Percent column label to select it.
  3. From the Edit menu or the right-click pop-up menu choose:

    Select > Data Cells

  4. From the Format menu or the right-click pop-up menu choose Cell Properties.
  5. Click the Format Value tab.
  6. Type 0 in the Decimals field to hide all decimal points in this column.
    Figure 2. Cell Properties, Format Value tab
    Cell Properties dialog with Format Value tab selected

    You can also change the data type and format in this dialog box.

  7. Select the type that you want from the Category list, and then select the format for that type in the Format list.
  8. Click OK or Apply to apply your changes.
Figure 3. Decimals hidden in Percent column
The Education Level table with the decimals hidden in the Percent column.

The decimals are now hidden in the Percent column.

Next