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.

SEE ALSO:  How to Delete Empty Rows in LibreOffice Calc Sheet

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

Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.

Join our Telegram channel and stay informed on the move.



IT professional by profession and founder of libreofficehelp.com. Loving Linux and other technologies since 2002. I believe in open source and its philosophy. Follow me on Twitter or email me.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.