Using Rounded Off Numbers /text/scalc/guide/rounding_numbers.xhp Sun Microsystems, Inc. numbers; rounded off rounded off numbers exact numbers in $[officename] Calc decimal places; showing changing;number of decimal places values;rounded in calculations calculating;rounded off values numbers; decimal places precision as shown rounding precision spreadsheets; values as shown mw reduced "tables in spreadsheets;" to "tables;" Using Rounded Off Numbers In $[officename] Calc, all decimal numbers are displayed rounded off to two decimal places.

To change this for selected cells

Mark all the cells you want to modify. Choose Format - Cells and go to the Numbers tab page. In the Category field, select Number. Under Options, change the number of Decimal places and exit the dialog with OK.

To change this everywhere

Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc. Go to the Calculate page. Modify the number of Decimal places and exit the dialog with OK.

To calculate with the rounded off numbers instead of the internal exact values

Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc. Go to the Calculate page. Mark the Precision as shown field and exit the dialog with OK.
Numbers Calculate