Home Screenshots 10 Languages Why use it?

Tip of the Day | Saturday February 7th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Show a Significant Number of Non-Zero Decimals...

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

Click ASAP Utilities › Numbers & Dates › 8. Show a Significant Number of Non-Zero Decimals...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Numbers & Dates › Show a Significant Number of Non-Zero Decimals...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.