How to Format Numbers as Currency in Microsoft Excel

When you are building a financial dashboard, an invoice, or a personal budget in Microsoft Excel, simply typing the number “5000” is often not clear enough. To make your financial data instantly recognizable and professional, you need to apply Currency or Accounting formatting. These formats automatically append the correct monetary symbol (like the Dollar sign or the Euro), insert thousand separators (commas), and standardize decimal places without altering the underlying mathematical value of the cell.

The Difference Between Currency and Accounting Formats

Before applying a format, it is important to understand that Excel offers two distinct ways to display money:

• Currency Format: This format places the currency symbol immediately next to the first digit of the number (e.g., $5,000.00). This is standard for general financial data and personal budgets.
• Accounting Format: This format is designed for professional ledgers. It forces the currency symbol to align perfectly on the far left edge of the cell, while the numbers align on the right edge. This creates a neat, easily scannable column of symbols and decimals. Additionally, the Accounting format displays a zero value as a simple dash (-) rather than a confusing $0.00.

How to Apply the Currency Format

If you want to apply the standard Currency format to a range of cells, follow these steps:

1. Click and drag your mouse to highlight the cells containing your financial numbers.
2. Click on the Home tab in the top ribbon menu.
3. Locate the “Number” group in the middle of the ribbon.
4. Click the large Format Dropdown Menu (it usually says “General” by default).
5. Select Currency from the list.

Your numbers will immediately update to display your region’s default currency symbol (based on your Windows OS settings) and two decimal places.

How to Apply the Accounting Format

Because the Accounting format is the professional standard, Excel provides a dedicated quick-access button for it on the ribbon.

1. Highlight the cells you wish to format.
2. In the Home tab, look at the “Number” group again.
3. Click the button that looks like a stack of coins with a dollar sign (the Accounting Number Format button).

If you need to change the currency symbol (for example, switching from Dollars to British Pounds), do not click the main icon. Instead, click the tiny drop-down arrow immediately next to the Accounting button. This will reveal a menu allowing you to quickly select £ English (U.K.), € Euro, or ¥ Chinese Yuan.