Using Rounded Off Numbers
In LibreOffice 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 \<emph\>Format - Cells\</emph\> and go to the \<emph\>Numbers\</emph\> tab page.
-
In the \<emph\>Category\</emph\> field, select \<emph\>Number\</emph\>. Under \<emph\>Options\</emph\>, change the number of \<emph\>Decimal places\</emph\> and exit the dialog with OK.
To change this everywhere
-
Choose LibreOffice - PreferencesTools - Options - LibreOffice Calc.
-
Go to the \<emph\>Calculate\</emph\> page. Modify the number of \<emph\>Decimal places\</emph\> and exit the dialog with OK.
To calculate with the rounded off numbers instead of the internal exact values
-
Choose LibreOffice - PreferencesTools - Options - LibreOffice Calc.
-
Go to the \<emph\>Calculate\</emph\> page. Mark the\<emph\> Precision as shown\</emph\> field and exit the dialog with OK.