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 4-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 |