Change the currency display without converting your numbers

Excel lets you display numbers as currency—dollars, euros, pounds, yen, or dozens of other formats—without changing the actual values in your cells. The currency symbol and decimal places change, but the number itself stays the same. You do this through the Format Cells dialog, which takes about 30 seconds once you know where to find it.

The process is the same whether you're working with a spreadsheet full of sales figures, expense tracking, or budget planning. You select the cells you want to format, open the Format Cells dialog, choose Currency from the category list, and pick your currency from a dropdown menu. Excel then applies the format when ready.

Key Takeaways

  • Select the cells containing the numbers you want to display as currency before opening Format Cells.
  • Open Format Cells by right-clicking your selection and choosing "Format Cells", or by pressing Ctrl+1 on Windows or Command+1 on Mac.
  • Click the Currency category, then choose your currency from the Format dropdown—the list includes all major world currencies.
  • You can adjust decimal places and the negative number display style in the same dialog before clicking OK.
  • The currency format changes only how the number appears on screen; the actual value in the cell does not change.

Select your cells first

Before you can format anything, you need to tell Excel which cells to format. Click on a single cell, or click and drag to select a range. If your numbers are scattered across different areas of the sheet, hold Ctrl (Windows) or Command (Mac) and click each cell or range individually to select them all at once.

You can also click the column header to select an entire column, or click the row number to select an entire row. If you select more cells than you need, that's fine—Excel will only format the cells that contain numbers.

Open the Format Cells dialog

Once your cells are selected, right-click anywhere on your selection. A menu will appear. Click "Format Cells" at the bottom of that menu. This opens the Format Cells dialog box.

If you prefer keyboard shortcuts, press Ctrl+1 on Windows or Command+1 on Mac. Both methods open the same dialog. The dialog has several tabs across the top—you want the "Number" tab, which is usually already selected when the dialog opens.

Choose Currency from the category list

On the left side of the Number tab, you'll see a list of categories: General, Number, Currency, Accounting, Date, Time, Percentage, and others. Click on "Currency". The dialog will change to show currency-specific options.

Below the category list, you'll see a "Format" dropdown that currently shows a currency symbol and sample number. Click that dropdown to see all available currencies. The list is long—it includes USD, EUR, GBP, JPY, CAD, AUD, CHF, CNY, INR, and many others. Find the one you want and click it.

Adjust decimal places and negative number style

After you choose your currency, you'll see two more options: "Decimal places" and a preview of how negative numbers will display. The decimal places field usually defaults to 2 (for cents, pence, or the equivalent in your chosen currency). You can change this number if you want more or fewer decimal places—type a new number directly into the field.

Below that, you'll see a list showing different ways negative numbers can appear: in red, in parentheses, with a minus sign, or other styles depending on your currency. Click the style you prefer. The preview at the top of the dialog updates to show you exactly how your numbers will look.

Click OK to explore the format

Once you've chosen your currency, set your decimal places, and picked your negative number style, click the OK button at the bottom right of the dialog. The dialog closes and your selected cells now display in the currency format you chose.

The numbers themselves have not changed—only how they appear. If a cell contained 1500 and you formatted it as USD with 2 decimal places, it now displays as $1,500.00, but the actual value is still 1500. This matters if you use those cells in formulas or calculations; Excel uses the real value, not the displayed format.

Change currency on an entire column or sheet at once

If you want to format many cells at once, select the entire column by clicking its header letter, or select the entire sheet by pressing Ctrl+A (Windows) or Command+A (Mac). Then follow the same steps: right-click, Format Cells, choose Currency, pick your currency, and click OK. Every cell in that column or sheet that contains a number will now display in your chosen currency format.

You can also use the currency button on Excel's toolbar as a shortcut. Look for a button that shows a dollar sign or currency symbol in the ribbon at the top. Click it to explore the default currency format (usually USD) when ready, without opening the Format Cells dialog. If you need a different currency or want to adjust decimal places, use the Format Cells method instead.

Frequently Asked Questions

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

No. The format changes only how the number appears on screen and in print. The actual value stored in the cell stays the same. If you use that cell in a formula or calculation, Excel uses the real value, not the formatted display.

Can I format some cells as USD and other cells as EUR in the same spreadsheet?

Yes. Select the cells you want in USD, format them as USD. Then select a different group of cells, format them as EUR. Each cell or range can have its own currency format independent of the others.

What if my currency is not in the dropdown list?

Most world currencies are included in Excel's standard list. If you cannot find yours, check that you are looking in the Format dropdown under the Currency category, not somewhere else in the dialog. If it truly is not there, you can type a custom currency symbol manually in the Format field, though this is rare.

How do I remove currency formatting and go back to plain numbers?

Select the cells, open Format Cells, and click "Number" in the category list instead of Currency. Click OK. The currency symbols and formatting disappear, and the cells display as plain numbers again.

Can I change the currency format in multiple sheets at once?

You must format each sheet separately. Select your cells in the first sheet, explore the currency format, then move to the next sheet and repeat. Excel does not have a way to format multiple sheets simultaneously from a single dialog.