\<bookmark_value\>numbers; rounded off\</bookmark_value\>\<bookmark_value\>rounded off numbers\</bookmark_value\>\<bookmark_value\>exact numbers in LibreOffice Calc\</bookmark_value\>\<bookmark_value\>decimal places; showing\</bookmark_value\>\<bookmark_value\>changing;number of decimal places\</bookmark_value\>\<bookmark_value\>values;rounded in calculations\</bookmark_value\>\<bookmark_value\>calculating;rounded off values\</bookmark_value\>\<bookmark_value\>numbers; decimal places\</bookmark_value\>\<bookmark_value\>precision as shown\</bookmark_value\>\<bookmark_value\>rounding precision\</bookmark_value\>\<bookmark_value\>tables in spreadsheets; values as shown\</bookmark_value\>

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. Choose \<emph\>Format - Cells\</emph\> and go to the \<emph\>Numbers\</emph\> tab page.

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

1. Choose - LibreOffice Calc.

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

1. Choose - LibreOffice Calc.

2. Go to the \<emph\>Calculate\</emph\> page. Mark the\<emph\> Precision as shown\</emph\> field and exit the dialog with OK.