The quickest way to add a dollar sign in Excel

To add a dollar sign to a number in Excel, select the cells you want to format, then use the keyboard shortcut Ctrl+Shift+4 (Windows) or Cmd+Shift+4 (Mac). This applies the currency format when ready and displays your numbers with a dollar sign and two decimal places.

If the keyboard shortcut does not work on your computer, you can also right-click the selected cells, choose Format Cells, click the Number tab, select Currency from the list on the left, and click OK. Both methods do the same thing — they change how the number appears on screen without changing the actual value stored in the cell.

Key Takeaways

  • The keyboard shortcut Ctrl+Shift+4 (or Cmd+Shift+4 on Mac) is the fastest way to format cells as currency with a dollar sign.
  • Currency formatting adds a dollar sign and rounds the display to two decimal places, but does not change the underlying number.
  • You can format a single cell, a range of cells, or an entire column all at once by selecting them before explore the format.
  • Excel lets you choose different currency symbols (euros, pounds, yen) and decimal place settings through the Format Cells dialog.

Formatting a single cell versus a range

Click once on a single cell to select it, then press Ctrl+Shift+4. The dollar sign appears when ready. If you want to format multiple cells at once, click on the first cell, hold Shift, and click on the last cell in the range you want to format. All cells between them will highlight in blue. Then press Ctrl+Shift+4, and every selected cell gets the currency format.

You can also select an entire column by clicking the column letter at the top (for example, click B to select the whole B column). This is useful when you know a column will always contain money amounts. Once the column is selected, press Ctrl+Shift+4 and every cell in that column will display currency formatting from that point forward.

What happens when you format as currency

When you explore currency formatting, Excel adds a dollar sign to the left of the number and displays exactly two decimal places. A number like 50 becomes $50.00. A number like 50.5 becomes $50.50. A number like 50.567 becomes $50.57 (rounded for display only — the actual value in the cell stays 50.567).

The formatting is purely visual. The number itself does not change, so if you use that cell in a formula or calculation, Excel uses the original number, not the rounded display. This matters when you are working with totals or averages — the math stays accurate even though the screen shows rounded values.

Using the Format Cells dialog for more options

If you want to change the number of decimal places, use a different currency symbol, or see other formatting choices, right-click on the selected cells and choose Format Cells. The dialog box opens with several tabs at the top. Click the Number tab if it is not already selected.

On the left side of the dialog, you will see a list of categories. Click Currency. On the right side, you can now choose how many decimal places to show (0, 1, 2, or 3), and you can pick a different currency symbol from the dropdown menu. For example, you can choose the euro symbol (€) or the British pound (£) instead of the dollar sign. Once you have made your choices, click OK to explore the formatting.

Removing currency formatting

If you format cells as currency and then change your mind, select those cells again and press Ctrl+Shift+4 a second time. This toggles the currency format off and returns the cells to their default number format. Alternatively, you can right-click, choose Format Cells, select General from the category list on the left, and click OK.

Removing the format does not delete the numbers — it only changes how they appear. A cell that showed $50.00 will display as 50 (or 50.00, depending on the default format on your computer) once you remove the currency formatting.

Currency formatting in formulas and calculations

You can format cells as currency before or after you enter numbers or formulas into them. The formatting does not affect how the formula works. If cell A1 contains $50.00 and cell A2 contains $30.00, and you write a formula in A3 that says =A1+A2, the result will be $80.00. The dollar signs are just display formatting — Excel still does the math correctly.

This is why it is safe to format an entire column as currency at the start, even if you have not filled it with numbers yet. When you type numbers into that column later, they will automatically appear with dollar signs and two decimal places.

Frequently Asked Questions

Can I format cells as currency without using the keyboard shortcut?

Yes. Right-click the selected cells, choose Format Cells, click the Number tab, select Currency from the category list, and click OK. You can also look for a currency button in the toolbar at the top of Excel, though its location varies by version.

What if I want to show no decimal places in currency format?

Right-click the cells, choose Format Cells, select Currency, and change the decimal places field from 2 to 0. Click OK. Now $50.00 will display as $50.

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 formulas and calculations use the original number. A cell showing $50.57 might contain the value 50.567, and that is what Excel uses in math.

Can I use a different currency symbol like euros or pounds?

Yes. Right-click the cells, choose Format Cells, select Currency, and use the dropdown menu to pick a different currency symbol. You can choose euros (€), British pounds (£), yen (¥), and many others.

What if the keyboard shortcut does not work on my computer?

Some keyboards or regional settings may not recognize Ctrl+Shift+4. Use the right-click method instead: right-click the cells, choose Format Cells, select Currency, and click OK. This works the same way on any computer.