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:
For example, the value 1234.567:
This is helpful when you want to round values permanently for reports, exports, or data consistency, without using formulas.
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

.png)

Additional search terms to help you find this tool:
Round numbers in Excel without formula, Permanently round numbers, Round numbers and replace values, Round numbers without changing format, Round cell values without using formulas, Replace values with rounded numbers, Round decimals permanently, Round numbers to nearest 10 or 100 in Excel, Limit number of decimals in Excel without formatting
Tip:Alt+P for the previous tool.
Tip: Alt+N for the next tool.
Start saving time in Excel with practical tools you can use right away.
No sign-up required.
Free 90-day trial