How to Add a Money Sign in Excel: Formatting Currency the Right Way

Whether you're building a budget spreadsheet, tracking invoices, or presenting financial data, knowing how to add a money sign in Excel is a fundamental skill. Excel gives you several ways to display currency symbols — and the method you choose affects more than just appearance. It can impact how your data behaves in formulas, how it prints, and how others interpret it.

What "Adding a Money Sign" Actually Means in Excel

There's an important distinction to understand before diving in: displaying a dollar sign (or any currency symbol) is different from typing one directly into a cell.

• Typed symbol — You manually type $500 into a cell. Excel may treat this as text, not a number, which breaks formulas.
• Number formatting — Excel stores the value as a number (500) and displays the currency symbol visually. Formulas still work correctly.

For financial spreadsheets, number formatting is almost always the right approach. It keeps your data clean and calculable.

Method 1: Using the Currency Format Button 💰

The fastest way to apply a dollar sign in Excel:

1. Select the cell or range you want to format
2. Go to the Home tab on the ribbon
3. In the Number group, click the $ button (Accounting Number Format)

This applies Excel's default Accounting format, which:

• Aligns the $ symbol to the left edge of the cell
• Aligns the number to the right
• Displays two decimal places by default (e.g., $ 1,250.00)
• Shows negative numbers in parentheses

This is the format most commonly used in professional financial documents.

Method 2: Format Cells Dialog (More Control)

For more flexibility over how the currency symbol appears:

1. Select your cells
2. Press Ctrl + 1 (or right-click → Format Cells)
3. Click the Number tab
4. Choose either Currency or Accounting from the category list
5. Set your decimal places and choose your symbol from the dropdown

The Currency and Accounting formats behave slightly differently:

Both are valid — the choice depends on the visual standard you're working toward.

Method 3: Keyboard Shortcut

If you want to apply the Accounting format quickly without touching the ribbon:

• Select your cells and press Ctrl + Shift + $

This applies the same Accounting Number Format as the ribbon button, instantly.

Method 4: Typing a Currency Symbol Directly

Sometimes you genuinely need to type a symbol — for a label, a header, or a non-numeric cell. In that case:

• Dollar sign: Hold Shift and press 4 → $
• Euro sign: Hold Alt and type 0128 on the numeric keypad → €
• British pound: Hold Alt and type 0163 → £
• Japanese yen: Hold Alt and type 0165 → ¥

On a Mac, the shortcuts differ slightly — Option + 2 gives € depending on keyboard layout and region settings.

⚠️ If you type a currency symbol directly in front of a number, double-check whether Excel has interpreted it as a number or as text. Look at the alignment — numbers right-align by default, text left-aligns.

How to Add Non-Dollar Currency Symbols via Formatting

If you're working with euros, pounds, or other currencies, the Format Cells dialog lets you swap the symbol:

1. Open Format Cells (Ctrl + 1)
2. Select Currency or Accounting
3. Open the Symbol dropdown
4. Choose from the list (€ Euro, £ Pound, ¥ Yen, and many others)

This keeps the underlying number intact while displaying the correct regional symbol.

What About the Dollar Sign in Formulas? (Cell References)

Here's a related concept that trips up many Excel users: the $ sign in formulas means something completely different. It has nothing to do with currency.

In a formula like =$B$2*C3, the dollar signs lock a cell reference so it doesn't shift when you copy the formula to other cells. This is called an absolute reference.

• $B$2 — both column and row are locked
• $B2 — only the column is locked
• B$2 — only the row is locked

This is a formula behavior, not a display format. Understanding this distinction prevents confusion when you're both formatting currency and writing formulas in the same sheet.

Variables That Affect Which Method Works Best for You

The right approach depends on a few factors specific to your setup and workflow:

• Excel version — Desktop Excel (Microsoft 365, Excel 2019/2021), Excel for Mac, and Excel Online all support these methods, but keyboard shortcuts and some dialog layouts vary slightly across versions
• Regional settings — Your operating system's locale affects which currency symbol Excel defaults to and how it formats numbers (comma vs. period as decimal separator)
• How the data will be used — Exported to CSV, shared as a PDF, used in pivot tables, or pulled into Power BI each have different formatting considerations
• Single currency vs. mixed currencies — A sheet tracking multiple currencies may need custom number formats rather than a single global format
• Collaboration — If others open your file in a different regional setting, currency symbols and number formats can display differently than intended

The mechanics of applying a money sign in Excel are straightforward — but whether the Accounting format, Currency format, or a custom approach fits your specific spreadsheet depends entirely on what you're building and who's using it.