Use a significant number of decimal places

Number > Use a significant number of decimals

This utility rounds numbers in cells to display a significant number of digits after the decimal point.

You can choose from the following:

• Apply formatting;
• Round off physically.

The difference between this utility and general rounding is that it ignores zeros that come 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, excluding zero.

A cell with a value of "18.0125142" will be displayed as "18.0125" instead of "18.013".

A cell with the value "18.00007693" will be displayed as "18.0000769" instead of "18.000".

Screenshot

After application:

Running this tool

Click YLC Utilities > Number > Use a significant number of decimals :

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Use a significant number of decimals by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .