Using Rounded Off Numbers

In LibreOffice Calc, all decimal numbers are displayed rounded off to two decimal places.

To change this for selected cells

  1. Mark all the cells you want to modify.

  2. Izvēlieties Formatēt - Šūnas un dodieties uz Skaitļi cilnes lappusi.

  3. In the Category field, select Number. Under Options, change the number of Decimal places and exit the dialog with OK.

To change this everywhere

  1. Izvēlieties - LibreOffice Calc.

  2. 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

  1. Izvēlieties - LibreOffice Calc.

  2. Go to the Calculate page. Mark the Precision as shown field and exit the dialog with OK.