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

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.


Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials and no BS. Connect with me via Telegram, Twitter, LinkedIn, or send us an email.

Notify of

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

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x