Ampler increases or decreases the decimal places of selected numbers with a keyboard shortcut, so you set precision without the Format Cells dialog.
Quick answer: Select the cells and press Ctrl+, (comma) to increase decimals or Ctrl+. (dot) to decrease — or use the Increase/Decrease decimal functions in the Ampler tab’s Number group.
How to use it
Add or remove decimal places with a shortcut.
- Select the cells with the numbers.
- Click Increase decimal or Decrease decimal, or press Ctrl+, (comma) or Ctrl+. (dot).
Keyboard shortcut
Ctrl+, increases and Ctrl+. decreases decimal places; the functions are also in the Ampler tab’s Number group.
Why use it
Adjusting precision cell by cell through the Format Cells dialog is slow. Ampler puts increase- and decrease-decimal on a keyboard shortcut, so you tune the precision of a figure or a range instantly.
How consultants use it
The right precision matters in a model — too many decimals is noise, too few loses information. Three habits apply:
- Precision to suit the figure: decimals are set to what the number needs
- Fast on a range: a whole selection is adjusted in a keystroke
- Consistent within a table: related figures share the same precision
Shortcut decimal control tunes precision without the Format Cells dialog.
Tips & best practices
- Use Ctrl+, and Ctrl+. to tune precision fast.
- Keep related figures at the same precision.
- Avoid excess decimals that add noise.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you add or remove decimal places in Excel with a shortcut?
Select the cells and press Ctrl+, (comma) to increase decimals or Ctrl+. (dot) to decrease, using Ampler.
Where are the decimal functions in Ampler?
In the Number group on the Ampler tab, as well as on the keyboard shortcuts.
What are the shortcuts for decimals?
Ctrl+, to increase and Ctrl+. to decrease decimal places.
Does decreasing decimals in Excel round the number or just hide it?
It changes only what is displayed — the underlying value keeps its full precision, because decrease-decimal is a formatting change. To change the actual stored value, use the ROUND function, or switch on Excel’s Precision as displayed option.
Why does my column total look wrong after I remove decimal places?
Because the rounded cells still add up by their true, unrounded values, so a total can look a cent or two “off” from the figures shown. If you need the total to match the displayed numbers, round the values themselves with the ROUND function, or turn on Precision as displayed.