Precision Options

In Precision options, select options to set the number of decimal positions displayed in a cell for Currency Values, Non-Currency Values, and Percentage Values.

Specify minimum values to add zeros to numbers with few decimal places. Specify maximum values to truncate and round the decimal portion of longer numbers. For example:

Table 3. Data Precision Examples

Value

Minimum Precision

Maximum Precision

Displayed Value

100

0

Any

100

100

3

Any number greater than or equal to 3 or None

100.000

100.12345

Any number less than or equal to 5

None

100.12345

100.12345

7

None

100.1234500

100.12345

Any number less than or equal to 3

3

100.123

100.12345

0

0

100

100.12345

2

4

100.1234

100

2

4

100.00