Excel Decrease Decimal Shortcut: Steps, Mac, and Fixes

In Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, 9 to decrease the displayed decimal places by one. Press the keys in sequence—not all at once. This changes how the numbers look, not the values stored in the cells.

How to use the shortcut in Excel for Windows

The shortcut follows the Key Tips for the Home tab and its Decrease Decimal command. To use it:

Select one cell, a range, or multiple nonadjacent cells. The command applies to the selected cells.
Press and release Alt. Excel displays Key Tips on the ribbon.
Press H to open the Home tab’s Key Tips.
Press 9 to choose Decrease Decimal.

For example, with a cell displaying 18.476, one press usually changes its display to 18.48; another changes it to 18.5. The exact visible result depends on the cell’s number format and the value. Excel rounds the displayed figure to fit the chosen number of decimal places, while retaining the underlying value for calculations.

The shortcut is a ribbon Key Tip sequence, so it is not a single dedicated key combination. If you use it often, you can leave the cell selected and repeat the sequence to reduce the displayed precision further.

What Decrease Decimal changes—and what it does not

Decrease Decimal changes a cell’s number format: specifically, how many digits appear to the right of the decimal separator. It does not delete digits from the stored number, rewrite a formula, or permanently round the source value. A cell can therefore display 18.5 while still holding a more precise value such as 18.476.

This distinction matters when you use displayed figures in calculations. Suppose a price is stored as 4.995 but displayed with two decimal places as 5.00. A total or another formula can still use 4.995, not the rounded-looking 5.00. Excel generally calculates with the stored value unless a formula or workbook setting changes that behavior.

Changing the display is often the right choice for reports, summaries, and tables where fewer digits make the information easier to scan. It is not the same as changing the data’s precision. If a business rule requires values to be rounded before further calculations, use a rounding formula or replace values deliberately rather than relying on the display button.

Decrease Decimal versus Increase Decimal

The matching ribbon command, Increase Decimal, adds a displayed decimal place. In Windows Excel for Microsoft 365, its Key Tip sequence is Alt, H, 0. The two commands work on the selected cells and adjust the displayed decimal places one place at a time.

For example, a value displayed as 7.2 can be shown as 7.20 after increasing the decimal places. That extra zero does not add precision to the stored value; it only makes the chosen display consistent. This is useful for amounts or measurements where a uniform number of digits helps readers compare rows.

Use Decrease Decimal when extra digits clutter the view, and Increase Decimal when you need more detail or consistent formatting. Neither command is a substitute for checking the value in the formula bar or changing a calculation’s rounding rules.

Apply the change to a range or a whole column

You do not have to format cells one at a time. Select a range before using the shortcut, and Excel applies the display change to each selected cell that supports the number format. To format an entire column, click its column letter, then use Alt, H, 9. You can also select a block by dragging across cells or by clicking the first cell and Shift-clicking the last.

For nonadjacent selections, hold Ctrl while selecting additional cells or ranges on Windows, then run the shortcut once. Be cautious when formatting a whole column: text and dates may not respond as expected, and changing a number format can affect how numeric entries appear. If the selection includes different kinds of data, inspect the result before moving on.

To undo a formatting change immediately, press Ctrl+Z on Windows. Undo reverses the recent action, but it is not a replacement for checking the intended range. If the workbook has other changes you want to keep, you can instead reselect the affected cells and use Increase Decimal or open Format Cells to set the desired display directly.

Set an exact number of decimal places

The shortcut is convenient for one-place adjustments. For a precise setting, select the cells and open Format Cells with Ctrl+1 on Windows. In the dialog, choose the Number category and enter the desired number in Decimal places. The Number category also provides options such as a thousands separator and a negative-number style.

You can also use the Number group on the Home tab to select a format or open the number-formatting dialog. The ribbon’s Decrease Decimal button is useful for quick refinements; the dialog is clearer when you need a specific number of places, want to set other number-format options, or need to understand what format is currently applied.

Number formats can include more than decimal-place counts. Currency, Percentage, Date, and other formats each control how a value is presented. For instance, reducing decimals on a percentage changes the digits shown after the percent sign; it does not convert the value to a different percentage. Check the format category when a result looks surprising.

When you need to change the actual value

If the goal is to calculate a rounded result rather than merely hide digits, use Excel’s ROUND function. With the original number in A2, the formula =ROUND(A2,2) returns that number rounded to two decimal places. If A2 contains 18.476, the result is 18.48. The formula returns a rounded result in its own cell; it does not alter A2.

For other needs, Excel also provides ROUNDUP and ROUNDDOWN, which round in a specified direction. Choose the rule that matches the task rather than assuming that a smaller number of visible digits means the underlying value has been rounded. For financial, tax, or measurement work, follow the applicable rules for when and how rounding should occur.

There is also an Excel setting called Set precision as displayed in the Advanced options. Enabling it can permanently change stored values to match their displayed precision, and the change can affect values throughout the workbook. It is not a routine shortcut for reducing decimals. Make a backup and understand the consequences before enabling it; ordinary number formatting is safer when you only want a cleaner display.

Mac and Excel for the web

The Alt, H, 9 Key Tip sequence described above is for Excel on Windows. Excel for Mac has a different keyboard and ribbon environment, so do not assume that the Windows sequence will work there. On a Mac, select the cells and use the Decrease Decimal command on the Home tab’s number-formatting controls. You can also open Format Cells to set the number of decimal places directly.

In Excel for the web, the most dependable method is to select the cells and use the Decrease Decimal control on the Home tab. Keyboard access can depend on the browser and the way ribbon Key Tips are exposed, so the Windows desktop sequence may not behave identically. If a shortcut is intercepted by the browser or does not display Excel’s Key Tips, use the ribbon command instead.

Across these versions, the central distinction remains the same: the decrease-decimal command changes presentation, not the underlying numerical value. If you share a workbook, recipients may see the same formatting, but formulas still use the stored numbers unless rounding is built into the calculations.

Common problems and quick checks

If pressing the sequence does nothing, check that Excel—not another application or dialog—is active, and that you pressed the keys one after another. Press Alt first and look for Key Tips; then continue with H and 9. If your keyboard or system uses different key behavior, click the ribbon control as a fallback.

The number seems unchanged: It may already display zero decimal places, or the selected cell may contain text rather than a numeric value. Check the formula bar and try the command on a known numeric cell.
The result appears rounded: That is the normal display effect. Increase the decimal places again to reveal more of the stored value.
A date or percentage changes unexpectedly: These are specialized number formats. Inspect the format category before applying the command broadly.
Only some cells respond: The selection may include text, blanks, or cells with different formats. Verify the selected range and test the command on a smaller sample.
You need exactly three decimal places: Use Format Cells and set Decimal places to 3 rather than pressing the shortcut repeatedly without checking the starting format.

One common misconception is that fewer displayed decimal places make a spreadsheet more accurate or change the value used in a total. Formatting can make a report easier to read, but it does not by itself change calculation precision. For reliable results, decide separately how values should be stored, calculated, and displayed.

Frequently Asked Questions

What is the shortcut to decrease decimal places in Excel?
In Excel for Microsoft 365 on Windows, select the cells and press Alt, H, 9 in sequence. This invokes Decrease Decimal on the Home tab.

Does Decrease Decimal round the actual number?
No. It changes the displayed number format. The stored value remains available to formulas unless you use a rounding formula or enable a setting that changes stored precision.

How do I increase decimal places with a shortcut?
On Windows, select the cells and press Alt, H, 0 in sequence to use Increase Decimal. On Mac or in Excel for the web, use the ribbon control if that Windows Key Tip sequence is unavailable.

Why does Alt, H, 9 not work in Excel?
Make sure Excel is active and that you are pressing the keys in sequence. The shortcut is a Windows ribbon Key Tip, not a simultaneous three-key combination. Browser, keyboard, or application focus can also interfere; use the Home tab’s Decrease Decimal command as a fallback.

How can I permanently round a value to two decimal places?
Use a rounding calculation, such as =ROUND(A2,2) when the original number is in A2. This returns a rounded result in the formula cell; it does not overwrite the source cell automatically.

Is there a Mac shortcut for Decrease Decimal?
The Windows sequence Alt, H, 9 is not a reliable Mac equivalent. On Excel for Mac, select the cells and choose Decrease Decimal from the Home tab, or set the exact decimal count in Format Cells.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.