By default, all decimal numbers are displayed as round
numbers to two decimal places. You can change this option for selected
cells or for a whole spreadsheet. You can also make sure that calculations
are performed using round numbers.
- To change this option for selected
cells
- Mark the cells that you want to
modify
- Click and click the Numbers tab.
- In the Category field, select Number.
Under Options, change the number of decimal
places and click OK.
- To permanently change this option everywhere
- Click .
- Click Calculate. Modify
the number
of decimal places displayed and click OK.
- To calculate with the rounded
numbers instead of the internal,
exact values
- Click .
- Click Calculate.
Select Precision
as shown and click OK.