You can set the format of data in tables and crosstabs. Click a row or column header and select Change Data Format from the context menu. In tables, the format is applied to all rows as well as the group- and view-level summaries. In crosstabs, the format is applied to the measures.

The options that appear in the menu are the formats available for objects of the given datatype. For example, for monetary datatypes, the menu might list $1,234.56, -$1,234.56 and ($1,234.56), while for date datatypes it might list December 31, 2008, and 12/31/2008. By default, non-integer fields use the -1,234.56 data format; integers use -1234.

In some cases, the options in the Change Data Format menu are affected by the locale; for example: