Accounting Number Format Excel Shortcut?

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select the cells and press Alt, H, A, N in sequence to apply the Accounting number format. These are ribbon KeyTips, not four keys to hold down together; if the sequence is unavailable in your Excel build, use Home > Number > Accounting Number Format.

What the Accounting format changes

Accounting is a number format for displaying monetary values in a consistent, ledger-style layout. It places currency symbols near the left edge of the cell and aligns decimal points and amounts vertically. This can make a column of figures easier to scan than values displayed with a currency symbol beside each number.

Formatting changes how a value looks, not the value stored in the cell. If a cell contains the number 1250.5, applying Accounting might display it as a dollar amount with two decimal places, but the stored value remains 1250.5. Excel can still add it, compare it, or use it in a formula as before.

  • Use Accounting for aligned financial columns, such as expenses, revenue, or balances.
  • Use it on a selected cell, a range, or an entire column.
  • Choose a currency symbol and decimal-place setting when the default display does not suit your sheet.

The format does not convert one currency into another, and it does not establish an exchange rate. It only displays the numeric value with a chosen symbol and layout.

How to use the Windows shortcut

The sequence Alt, H, A, N follows Excel’s ribbon KeyTips. Start with the cells selected, then press and release each key or key sequence in order. Do not press Alt, H, A, and N simultaneously. The letters guide Excel through the ribbon to the Accounting number-format command.

  1. Select the cells that contain the numbers you want to format. You can select a single cell, a range, or a column.
  2. Press and release Alt, then H, then A, then N.
  3. Check the result. Excel applies the Accounting format, usually using the default currency symbol and decimal setting for the workbook or regional configuration.

KeyTips are on-screen letters that appear when you press Alt and help you navigate ribbon commands with the keyboard. If the letters shown on your screen do not match this sequence, follow the displayed KeyTips instead. KeyTips can vary with Excel version, interface language, and ribbon customization. You can also open the Home tab and use the Accounting Number Format control directly.

The shortcut affects the selected cells, not every number in the workbook. To format a whole column, select its column heading first. Be careful when applying a number format to a column that also contains dates, identifiers, or text: those cells may not display as intended.

Use the ribbon or Format Cells dialog

For a mouse-based method, select the cells and choose Home > Number > Accounting Number Format. The main button applies the current Accounting style. Use the small arrow beside the button to choose a currency symbol when the menu offers alternatives. The exact symbol choices depend on the Excel setup and region.

For more control, select the cells and press Ctrl+1 to open Format Cells. On the Number tab, choose Accounting, set the number of decimal places, and select a symbol from the available list. Click OK to apply the settings. This dialog is useful when you need a particular symbol or precision rather than the default.

To change the visible number of decimal places after applying the format, use Home > Number > Increase Decimal or Decrease Decimal. These controls change the displayed precision. They do not round or replace the underlying value, although Excel’s display may show fewer digits than the cell actually contains.

Accounting versus Currency format

A frequent source of confusion is the difference between Accounting and Currency. The shortcut Ctrl+Shift+$ applies the Currency number format in Excel for Windows; it is not the standard Accounting shortcut. Currency typically displays the symbol close to the number, while Accounting aligns symbols and decimal points across a range. Both formats display numeric values as money, but their layouts differ.

Format Typical appearance Useful when
Accounting Currency symbols and decimal points align in a column; zero values may appear as a dash. You want a ledger-style column that is easy to compare vertically.
Currency The currency symbol appears beside each value. You want a compact, familiar price display, such as $12.50.
Number A numeric value appears without a currency symbol. The values are counts, measurements, or amounts where a symbol is unnecessary.

Exact display details, such as how negative values and zeros appear, can depend on the chosen format settings and regional conventions. If a workbook is intended for a particular reporting standard, check the displayed style rather than assuming every installation uses identical symbols or punctuation.

Excel on Mac and Excel for the web

The Windows KeyTip sequence is not a dependable Mac shortcut. In Excel for Mac, select the cells and use the Accounting Number Format control on the Home tab. To open the detailed number-format settings, select the cells and press Command+1, then choose Accounting on the Number tab. Keyboard behavior can vary with the Mac keyboard and Excel release, so the ribbon is the straightforward alternative.

Excel for the web also provides number-format controls on the Home tab. Select the cells, open the number-format options, and choose Accounting. The Windows desktop KeyTip sequence may not work the same way in a browser, because browser shortcuts and Excel for the web’s ribbon access can differ. If a shortcut is intercepted or does not bring up the expected command, use the ribbon rather than repeatedly trying combinations.

When switching between desktop and web versions, the workbook’s number format is generally part of the file, so a format applied in one version can be visible in another. However, a particular symbol or layout may render differently if the available fonts, locale, or format options differ.

Why the shortcut may seem not to work

If the displayed result does not change, first check that a numeric cell or range is selected. Text that looks like a number—perhaps imported with a leading apostrophe or stored as text—will not behave like an ordinary numeric value when formatted. The Accounting style may be applied, but the text can still look unchanged. Check the cell’s alignment, the formula bar, and any warning indicator to help identify text stored as a number.

Also check whether Excel is waiting for another KeyTip. Press Alt and look at the letters shown on screen, then follow the available prompts. If your Excel uses a different display language or a customized ribbon, the letter sequence can differ from the one commonly used in English-language Microsoft 365 for Windows.

  • Wrong money layout: You may have pressed Ctrl+Shift+$ and applied Currency rather than Accounting. Open the number-format menu and choose Accounting.
  • Unexpected symbol: Use the Accounting dropdown or Format Cells to select another available currency symbol.
  • Too many or too few decimals: Adjust decimal places in Format Cells or use the decimal buttons on the Home tab.
  • Nothing appears to change: Check whether the selected cells contain numeric values and whether the column is wide enough to show the result.

If a cell displays hash marks after formatting, the column may be too narrow for the formatted value. Widen the column or reduce the displayed decimal places. Hash marks do not usually mean the value has been erased.

Removing or changing the format

To replace Accounting with another display, select the cells and choose a different option from Home > Number, such as General, Number, or Currency. Choosing General removes the special number-format display and lets Excel show the value using its general rules. The underlying number remains available for calculations.

If you only need to remove the number format, avoid using Clear All without checking what else is in the selection. Clear All can remove other cell contents and formatting. Excel’s Home > Editing > Clear > Clear Formats command removes formatting while leaving cell values and formulas in place, but it also clears other formatting in the selected cells, not just the Accounting style.

Changing a format does not repair incorrect source data. For example, if an imported amount was stored as text, choosing General may not turn it into a usable number. Convert or correct the source value separately, then apply the desired number format.

Choosing the right display for a workbook

Accounting format is most useful when readers need to compare amounts down a column, especially in budget summaries, statements, and financial reports. Currency format can be more suitable for a short list of individual prices, where showing the symbol beside each amount makes the currency immediately obvious. Plain Number is often clearer for counts, rates, or values that are not being presented as money.

Consistency usually matters more than choosing one style for every situation. In a single table, use the same decimal precision and symbol for comparable amounts. If a report includes multiple currencies, label the columns clearly instead of relying on a symbol that could be ambiguous. For example, a dollar sign alone does not identify whether an amount is in U.S., Canadian, Australian, or another dollar currency.

Before sharing a workbook, review how zeros, negative values, and large numbers appear. A dash for zero can be helpful in a report, but readers should not mistake it for missing data. A clear heading, note, or legend can explain the convention when the spreadsheet will be read outside the team that prepared it.

Frequently Asked Questions

What is the shortcut for Accounting format in Excel?
In Excel for Microsoft 365 on Windows, select the cells and press Alt, H, A, N in sequence. These are ribbon KeyTips. If your interface shows different prompts, follow those prompts or use the Accounting Number Format control on the Home tab.

Is Ctrl+Shift+$ the Accounting shortcut?
No. In Excel for Windows, Ctrl+Shift+$ applies Currency formatting. Accounting uses a different ribbon command and aligns currency symbols and decimal points in a column.

Does Accounting format change the value in a cell?
No. It changes how the value is displayed, not the underlying number. A formatted numeric value remains available to formulas and calculations.

How do I change the currency symbol in Accounting format?
Select the cells, open the arrow beside the Accounting Number Format button, and choose an available symbol. For more options, press Ctrl+1 on Windows, choose Accounting on the Number tab, and select a symbol there.

What is the Accounting shortcut on a Mac?
The Windows Alt KeyTip sequence is not the Mac equivalent. Use the Accounting control on the Home tab, or press Command+1 to open Format Cells and choose Accounting on the Number tab.

Why does Excel show a dash instead of zero?
Accounting formats commonly display zero values as a dash, depending on the selected format and settings. The cell can still contain numeric zero; the dash is a display convention, not a missing value.

Related

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.