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.
Now, click on the “Delete Decimal Place” button from the toolbar.
Each time you click the button, Calc would reduce one decimal places and show a round off view of the number.
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.
To get back to the original number, click on the “Add Decimal Place” from the toolbar.
Looking for something else?
Be an expert on LibreOffice.
Small and quality tutorials. Delivered. Thrice a week.