Decimal Places in LibreOffice Calc

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.

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

Leave a Reply