PlayInfoBox

Home /Utilities /How to Align Currency Symbols with Accounting Number Format in Excel

How to Align Currency Symbols with Accounting Number Format in Excel

Tap each step to see how to apply Accounting format in Excel.

  1. Select the range of cells containing amounts

    Select the range of numeric data you want displayed with an aligned currency symbol.

  2. Open the Number Format dropdown on the Home tab

    In the Number group, click the number format dropdown, which defaults to "General."

  3. Choose "Accounting"

    Selecting Accounting from the list automatically pins the currency symbol to the left edge of the cell and right-aligns the numbers.

  4. Fine-tune decimals and the symbol in Format Cells

    Pressing Ctrl+1 opens Format Cells, where the Accounting category lets you fine-tune the decimal places and choose a different currency symbol.

  5. Why it helps

    When a column of amounts has different numbers of digits, Accounting format lines up currency symbols and decimal points neatly down the column, making the whole table much easier to read.

Amounts look crooked when digit counts differ?

Listing amounts like 1,000 and 10,000 side by side can look misaligned and messy. Accounting format automatically pins the currency symbol to the left of the cell and the number to the right, producing a much cleaner, more organized table.

Also worth learning: Paste Special to paste values only

When you're working with amount data, it's also worth knowing Paste Special's "Values Only" option, which lets you copy calculated results without carrying over the original formulas or formatting.

Frequently Asked Questions

How does Accounting format display a zero value?

In Accounting format, a zero is shown as a dash ("-") instead of a blank cell, making it easy to tell a true zero apart from an empty cell at a glance.

How is this different from Currency format?

Regular Currency format places the symbol immediately in front of the number, while Accounting format pins the symbol to the far left of the cell, which makes it much easier to compare a column of numbers vertically.