Decimal Places in LibreOffice Calc

By | February 18, 2018

This tutorial would explain how to show fewer decimal places in a Calc Cell.

Show Few Decimal Places

Any decimal number that contains multiple digits after the point can be entered in a Cell. However if the digits are huge, it is often wise to show only fewer digits for better visibility and understanding. For example, say a decimal number 4.175 is written in cell A1.

Before Reducing Decimal Places

Before Reducing Decimal Places


Now, click on the “Delete Decimal Place” button from the toolbar.

Toolbar - Decimal Places - Minus

Toolbar – Decimal Places – Minus


Each time you click the button, Calc would reduce one decimal places and show a round off view of the number.

After Reducing Decimal Places

After Reducing Decimal Places

Remember that, it is just the representation of the number that is changed, not the number itself. The internal number remains 4.175 but the representation is changed to 4.2.

SEE ALSO:  Maximum Number of Rows, Columns, Cells in LibreOffice Calc

If you want to perform any calculation on the decimal number while decimal view is reduced, Calc would consider the internal/actual decimal number with all decimal places i.e. 4.175 only.

Calculation when decimal is reduced

Calculation when decimal is reduced

To get back to the original number, click on the “Add Decimal Place” from the toolbar.

Toolbar - Decimal places - plus

Toolbar – Decimal places – plus

For the latest tutorials, news and how-to guides, follow on Twitter, Facebook, and subscribe to our YouTube channel and email updates via below form.

Join 568 other subscribers.