Change the currency display without altering the numbers

Excel stores numbers as numbers, not as currency. When you format a cell as currency, you are only changing how that number appears on screen — the underlying value stays the same. To change currency format, select the cells you want to modify, then use the Format Cells dialog or the currency button on the ribbon to pick a different currency symbol, decimal places, and negative number style.

The fastest route is the currency button on the Home tab. If you need more control — different decimal places, a specific currency code, or how negative numbers display — the Format Cells dialog gives you all those options in one place.

Key Takeaways

  • Select the cells containing the numbers you want to format as currency before you open any formatting tool.
  • The currency button on the Home tab applies your default currency format in one click, but offers no choices.
  • The Format Cells dialog (Ctrl+1 on Windows, Cmd+1 on Mac) lets you pick the specific currency, decimal places, and negative number format.
  • Changing currency format does not change the actual numbers in the cells, only how they display.
  • If you format a cell as currency and then change it back to General or Number format, the currency symbol disappears but the number remains.

Using the currency button for a quick format

The currency button sits on the Home tab of the ribbon, in the Number group. It looks like a dollar sign. Click it once to explore your default currency format — usually US dollars with two decimal places — to all selected cells.

This method is fast if your default currency is the one you need. If you want a different currency or different decimal places, skip this button and use Format Cells instead. The currency button has no dropdown menu and no options.

Choosing a specific currency in Format Cells

Open the Format Cells dialog by pressing Ctrl+1 on Windows or Cmd+1 on Mac. You can also right-click the selected cells and choose Format Cells from the menu. Click the Number tab if it is not already selected.

In the Category list on the left, click Currency. The dialog will show a Format list with currency options. Each option includes a currency symbol, the number of decimal places, and how negative numbers appear. Scroll through the list to find the currency you need — they are grouped by symbol ($ for US dollars, € for euros, £ for British pounds, and so on).

The Symbol dropdown at the bottom lets you pick a different currency symbol if the format you selected does not show the one you want. The Decimal places field controls how many digits appear after the decimal point. Once you have made your choices, click OK.

Changing decimal places for a currency format

In the Format Cells dialog, with Currency selected in the Category list, look for the Decimal places field. It usually shows a number like 2. Change this number to show more or fewer decimal places. Setting it to 0 removes the decimal point entirely. Setting it to 3 shows three digits after the decimal.

This change applies only to the cells you selected. Other cells with currency format keep their original decimal places unless you format them separately.

Controlling how negative numbers display

The Format list in the Currency category shows different ways to display negative numbers. Some formats show a minus sign in front (−$1,234.56), others show the number in red, and others put the number in parentheses ($1,234.56). Choose the format that matches your preference or your organization's standard.

Red formatting is visual only — it does not change the actual number, and printing in black and white will not show the color difference. If you need negative numbers to be clearly visible in all contexts, choose a format with parentheses or a minus sign.

Removing currency format and returning to plain numbers

Select the cells, open Format Cells (Ctrl+1 or Cmd+1), and click the Number tab. In the Category list, click Number or General. Click OK. The currency symbol disappears, but the number itself does not change.

If you want to remove the currency symbol but keep the number of decimal places and comma separators, choose Number instead of General. If you want the simplest possible display with no formatting, choose General.

explore currency format to a range or entire column

Select the range or column before you format. Click the column header to select an entire column, or click a cell and drag to select a range. You can also click the first cell, hold Shift, and click the last cell in the range you want.

Once the range is selected, use the currency button or Format Cells dialog as described above. The format applies to all selected cells at once. If you add new numbers to those cells later, they will automatically display in the currency format you chose.

Frequently Asked Questions

Does changing currency format change the actual numbers in my cells?

No. Currency format is display only. The number 1234.5 stored in a cell remains 1234.5 whether you display it as $1,234.50, €1.234,50, or 1234.5. If you use that cell in a formula, the formula uses the actual number, not the formatted display.

Why does my currency format show a different symbol than the one I picked?

Your computer's regional settings control which currency symbol appears by default. If you picked a format that says "English (United States)" but your computer is set to a different region, the symbol may not match. Use the Symbol dropdown in Format Cells to pick the exact symbol you want.

Can I create a custom currency format with a symbol that is not in the list?

Yes, but it requires typing a custom format code. In Format Cells, click the Number tab, select User-Defined in the Category list, and type a format code in the Type field. This is advanced and requires knowledge of Excel's format code syntax. For most users, the built-in currencies cover what you need.

What happens if I format a cell as currency and then paste a number into it?

The pasted number displays in the currency format you set for that cell. The format does not change based on what you paste — it stays the same until you change it manually.

Can I format negative numbers differently from positive ones without using currency format?

Yes. In Format Cells, select Number in the Category list instead of Currency. The Format list still shows options for displaying negative numbers in red, with parentheses, or with a minus sign. You can explore any of these styles to plain numbers as well as currency.