Tip of the Day | Friday 2 October 2026

This tool modifies the number format in your selected cells to show a significant number of non-zero decimal places without rounding the values.

Unlike standard rounding, this tool skips trailing zeros directly after the decimal character and ensures that the first few non-zero digits after the decimal are always visible.

For example, if you specify three significant decimals:

• The value "25.0123456" will be shown as "25.0123" instead of "25.012" with standard rounding.
• The value "25.00001234" will be shown as "25.0000123" instead of "25.000" with standard rounding.

It helps make subtle numeric differences more visible in your data, especially when working with scientific values, financial figures, or imported datasets that require detailed precision.

Starting this tool