Tip of the Day | Tuesday 4 August 2026

Discover new tools to get things done.

Permanently Round Numbers Without Using Formulas...

This tool rounds the actual numbers in your selected cells and replaces them with the rounded values.
Unlike cell formatting, which only changes how numbers look, this tool changes the actual values.

You can specify how it should round the numbers, similar to Excel's =ROUND() function:

  • A positive number rounds to that number of decimal places.
  • Zero rounds to the nearest whole number.
  • A negative number rounds to the left of the decimal (e.g., to tens, hundreds, thousands).

For example, the value 1234.567:

  • Rounded to 2 becomes 1234.57
  • Rounded to 0 becomes 1235
  • Rounded to -2 becomes 1200

This is helpful when you want to round values permanently for reports, exports, or data consistency, without using formulas.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: A Round the selected numbers to 2 decimals (Here's the English version.)
A Round the selected numbers to 2 decimals
Example screenshot: B Round the selected numbers to the nearest integer (zero decimal places) (Here's the English version.)
B Round the selected numbers to the nearest integer (zero decimal places)
Example screenshot: C Round the selected numbers to the nearest multiple of 100 (Here's the English version.)
C Round the selected numbers to the nearest multiple of 100

Tip:Alt+P for the previous tool.