The quickest way to format a number as currency

To add a dollar sign to a number in Excel, select the cell or range of cells containing the numbers, 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 click OK. Excel will instantly display your numbers with a dollar sign and two decimal places.

If you want to do this faster, select your cells and use the keyboard shortcut Ctrl+1 (Windows) or Command+1 (Mac) to open the Format Cells dialog directly. You can also use the currency button on the ribbon — it looks like a dollar sign and sits in the toolbar at the top of the screen.

Key Takeaways

  • Right-click any cell or range, choose Format Cells, select Currency from the Number tab, and click OK to add dollar signs.
  • The keyboard shortcut Ctrl+1 (Windows) or Command+1 (Mac) opens the Format Cells dialog without using the mouse.
  • The currency button on the ribbon (a dollar sign icon) formats selected cells as currency in one click.
  • Formatting changes how the number appears on screen but does not change the actual value stored in the cell.
  • You can choose how many decimal places to show and whether to display negative numbers in red or with a minus sign.

Using the currency button on the ribbon

The fastest single-click method is the currency button in the toolbar. Look for the icon that shows a dollar sign — it usually sits near other formatting buttons like bold and italic. Click on your cell or drag to select multiple cells, then click the currency button. Excel applies the default currency format (dollar sign, two decimal places) immediately.

This method works well if you are happy with the standard format. If you need to adjust the number of decimal places or change how negative numbers appear, you will need to open the Format Cells dialog instead.

Controlling decimal places and negative number display

When you format cells as currency, Excel shows two decimal places by default. To change this, open the Format Cells dialog (right-click and select Format Cells, or press Ctrl+1), click the Number tab, select Currency, and look for the Decimal places field. Type the number you want — zero if you do not want cents shown, or three or more if you need extra precision.

You can also control how negative numbers look. In the same Currency section, you will see a list of format options. Some show negative numbers in red, some use parentheses, and some use a minus sign. Choose the format that matches what you need for your spreadsheet.

Formatting a range of cells at once

You do not have to format each cell individually. Click on the first cell you want to format, then hold Shift and click on the last cell in the range you want to include. This selects all cells between them. Now right-click and choose Format Cells, or press Ctrl+1, and apply the currency format. Every cell in that range will update at once.

If the cells you want to format are not next to each other, hold Ctrl (Windows) or Command (Mac) and click on each cell individually. Then apply the currency format, and all selected cells will change together.

What formatting does and does not change

Adding a dollar sign through formatting changes only how the number appears on your screen — it does not change the actual value stored in the cell. If a cell contains 50 and you format it as currency, it displays as $50.00, but the underlying value is still 50. This matters if you use that cell in a formula, because the formula will still work with the number 50, not the text "$50.00".

This is why formatting is different from typing a dollar sign directly into a cell. If you type "$50" into a cell, Excel treats it as text, and you cannot use it in math. Formatting keeps the number as a number while just changing how it looks.

Removing currency formatting

If you format cells as currency and later want to remove the dollar signs, select the cells again, open Format Cells (Ctrl+1), click the Number tab, and select Number from the Category list instead of Currency. Click OK, and the dollar signs disappear while the numbers remain.

You can also right-click and choose Clear Formatting to remove all formatting from a cell at once, though this will also remove any other formatting you applied, like bold or background color.

Using the Format menu instead of right-click

If you prefer using the menu bar, you can also reach Format Cells through the top menu. Click Format in the menu bar, then select Cells from the dropdown. This opens the same Format Cells dialog you get from right-clicking, and you can proceed the same way — click the Number tab, select Currency, and click OK.

Some people find the menu method easier if they are not comfortable with right-clicking, or if they prefer to keep their hands on the keyboard. The result is identical no matter which method you use.

Frequently Asked Questions

Can I format cells as currency for other countries, like euros or pounds?

Yes. In the Format Cells dialog, select Currency from the Category list, then look for the Format dropdown. It shows different currency symbols — click the dropdown to see options like EUR (€), GBP (£), and others. Select the currency you need and click OK.

What if I want a dollar sign but no decimal places?

Open Format Cells, select Currency, and change the Decimal places field from 2 to 0. Click OK. Your numbers will display as $50 instead of $50.00. You can set decimal places to any number you want.

Does formatting as currency change how the number works in formulas?

No. Formatting only changes how the number appears on screen. If a cell contains 50 and you format it as currency to show $50.00, a formula that adds that cell to another number still uses 50, not the text "$50.00". The formatting does not affect calculations.

Can I format negative numbers to show in red?

Yes. In the Format Cells dialog under Currency, the format list shows different options for negative numbers. Some options display negative numbers in red with a minus sign, or in red with parentheses. Choose the format you want and click OK.

What is the difference between formatting and typing a dollar sign?

If you type "$50" directly into a cell, Excel treats it as text and you cannot use it in math. If you type 50 and then format the cell as currency, it displays as $50.00 but remains a number that works in formulas. Always format instead of typing the symbol.