This utility rounds numbers in cells to display a significant number of digits after the decimal point.
You can choose from the following:
The difference between this utility and general rounding is that it ignores the zeros immediately after the decimal separator.
For example, if you enter the number 3, the cells will be formatted to display at least 3 decimal places other than zero.
A cell with a value of "18.0125142" will be displayed as "18.0125" instead of "18.013".
A cell with a value of "18.00007693" will be displayed as "18.0000769" instead of "18.000".
After application:
Click
Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.
If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .