The quickest way to format a cell as currency

To add a dollar sign in Excel, select the cell or range of cells you want to format, then right-click and choose Format Cells. In the dialog box that opens, click the Number tab, select Currency from the Category list on the left, and choose $ English (United States) from the Format dropdown. Click OK. Excel will add the dollar sign and automatically format the number with two decimal places.

If you want to format cells faster, select them and use the keyboard shortcut Ctrl+1 (Windows) or Cmd+1 (Mac) to open the Format Cells dialog directly. You can also use the currency button on the ribbon: select your cells, then click the dollar sign icon in the toolbar. This applies the default currency format without opening any dialog.

Key Takeaways

  • Right-click a cell, choose Format Cells, select Currency, and pick the dollar format to add a dollar sign with automatic decimal places.
  • The currency button (dollar sign icon) in the toolbar applies currency formatting when ready without opening a dialog box.
  • Use Ctrl+1 (Windows) or Cmd+1 (Mac) to open the Format Cells dialog faster than right-clicking.
  • Currency formatting changes only how the number appears on screen — the actual value in the cell stays the same.
  • You can choose how many decimal places to show, whether to use parentheses for negative numbers, and which currency symbol to display.

Using the toolbar currency button for one-click formatting

The fastest way to add a dollar sign is the currency button on the ribbon. Select the cell or cells you want to format, then look for the dollar sign icon in the toolbar. In most versions of Excel, it sits in the Number group on the Home tab. Click it once, and Excel applies the default currency format when ready — usually a dollar sign, two decimal places, and thousands separators for numbers 1,000 and above.

This method works best when the default format matches what you need. If you want to change the number of decimal places, add parentheses around negative numbers, or use a different currency symbol, you will need to open the Format Cells dialog instead.

Customizing the currency format to match your needs

The default currency format shows two decimal places, but you can change this. Open the Format Cells dialog (right-click and select Format Cells, or press Ctrl+1), go to the Number tab, select Currency, and look for the Decimal places field. Type the number you want — 0 for whole dollars, 1 for one decimal place, or 3 for three decimal places. Click OK to explore the change.

You can also choose how negative numbers appear. In the Format list, you will see options like -$1,234.56 (with a minus sign) or ($1,234.56) (in parentheses). Accountants often prefer the parentheses format because it stands out more in financial statements. Select the format you want and click OK.

If you work with a currency other than US dollars, open Format Cells, select Currency, and choose a different country or region from the Format dropdown. Excel will change the currency symbol and adjust decimal places to match that country's standard.

Removing or changing currency formatting

If you format a cell as currency and later want to remove the dollar sign, right-click the cell and open Format Cells. On the Number tab, select Number from the Category list instead of Currency. Choose how many decimal places you want and click OK. The dollar sign will disappear, but the number itself stays the same.

To change from one currency to another, open Format Cells, stay on the Number tab with Currency selected, and pick a different country from the Format dropdown. Excel will swap the currency symbol without changing the number.

Why formatting is different from typing a dollar sign

You can type a dollar sign directly into a cell — just type $100 and press Enter. But this creates a text value, not a number. Excel will treat it as text, which means you cannot use it in calculations. If you add that cell to another number, Excel will not sum them correctly.

Using the currency format instead keeps the value as a number. Excel knows $100 is the number 100, so it can add, subtract, multiply, or divide it with other numbers. The dollar sign is just how the number looks on screen — the actual value stays numeric underneath. This is why formatting is the right approach for any cell you plan to use in a formula.

explore currency format to entire columns or ranges

You can format multiple cells at once. Click the column header to select an entire column, or click a cell and drag to select a range. Then right-click, choose Format Cells, select Currency, and click OK. Every cell in that selection will now show dollar signs and decimal places.

This is useful when you are building a budget or invoice template. Format the entire column where prices or totals will go, then fill in the numbers later. They will automatically display with dollar signs and proper decimal places as you type them.

Frequently Asked Questions

Can I add a dollar sign to just part of a cell?

No. Currency formatting applies to the entire cell value. If you want a dollar sign in front of text, you have to type it manually as part of the text — for example, type $100 for supplies. But if you do this, Excel treats the whole thing as text and cannot use it in math.

Why does my dollar sign show as a different symbol?

Excel may have defaulted to a different currency based on your computer's region settings. Open Format Cells, select Currency, and choose $ English (United States) from the Format dropdown to get the standard US dollar sign.

How do I remove the decimal places from currency formatting?

Open Format Cells, select Currency, and change the Decimal places field to 0. Click OK. The dollar sign will stay, but numbers like 100.00 will display as 100.

Does currency formatting change the actual number stored in the cell?

No. Formatting only changes how the number appears on screen. The actual value stays the same, so all your calculations will work correctly whether the cell shows a dollar sign or not.

Can I format cells as currency before I enter the numbers?

Yes. Select the cells where you plan to put prices or amounts, format them as currency, then type your numbers. They will automatically display with dollar signs and decimal places as you enter them.