User Guide

289
Pivot Tables
E
From the context menu choose Cell Properties.
E Click the Value tab.
E Select the format you want to apply to the column.
You can use this method to suppress or add percentage signs and dollar signs, change
the number of decimals displayed, and switch between scientific notation and regular
numeric dis
play.
Cell Properties: Alignment
This dialog box tab sets horizontal and vertical alignment and text direction for a
cell. If yo
u choose Mixed, contents of the cell are aligned according to its type
(number, date, or text).
Figure 11-
18
Cell Prope
rties dialog box, Alignment t ab
To Change Alignment in Cells
E Select a cell in the table.