Display numbers as currency

If you want to display numbers as monetary values, you must format those numbers as currency. To do this, you apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are available on the Home tab, in the Number group.

Number group on the Home tab

In this article

What's the difference between the Currency and Accounting formats?

Display numbers as currency

Remove currency formatting

Create a workbook template with specific currency formatting settings

What's the difference between the Currency and Accounting formats?

Both the Currency and Accounting formats are used to display monetary values. The difference between the two formats is explained in the following table.

Format

Description

Example

Currency

When you apply the Currency format to a number, the currency symbol appears right next to the first digit in the cell. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers.

Tip: To quickly apply the Currency format, select the cell or range of cells that you want to format, and then press CTRL+SHIFT+$.

Currency number format applied to cells

Format

Description

Example

Accounting

Like the Currency format, the Accounting format is used for monetary values. However, this format aligns the currency symbols and decimal points of numbers in a column. In addition, the Accounting format displays zeros as dashes and negative numbers in parentheses. Like the Currency format, you can specify how many decimal places you want and whether to use a thousands separator. However, you cannot change the default display of negative numbers unless you create a custom number format.

Tip: To quickly apply the Accounting format, select the cell or range of cells that you want to format. On the Home tab, in the Number group, click Accounting Number Format Accounting number format button . If you want to show a currency symbol other than the default, click the arrow next to the Accounting Number Format Accounting number format button button and then select another currency symbol.

Accounting number format applied to cells

Top of Page

Display numbers as currency

As mentioned earlier, you can quickly display a number with the default currency symbol by selecting the cell or range of cells, and then clicking Accounting Number Format Accounting number format button in the Number group on the Home tab. (If you want to apply the Currency format instead, select the cells, and press CTRL+SHIFT+$.)

If you want more control over either format, or you want to change other aspects of formatting for your selection, you can follow these steps.

Select the cells you want to format

On the Home tab, click the Dialog Box Launcher next to Number.

Dialog Box Launcher in Number group

Tip: You can also press CTRL+1 to open the Format Cells dialog box.

In the Format Cells dialog box, in the Category list, click Currency or Accounting.

Format Cells dialog box

In the Symbol box, click the currency symbol that you want.

Note: If you want to display a monetary value without a currency symbol, you can click None.

In the Decimal places box, enter the number of decimal places that you want for the number. For example, to display $138,691 instead of $138,690.63 in the cell, enter 0 in the Decimal places box.

As you make changes, watch the number in the Sample box. It shows you how changing the decimal places will affect the display of a number.

In the Negative numbers box, select the display style you want to use for negative numbers. If you don't like the existing options for displaying negative numbers, you can create your own number format. For more information about creating custom formats, see Create or delete a custom number format.

Note: The Negative numbers box is not available for the Accounting number format. That's because it is standard accounting practice to always show negative numbers in parentheses.

To close the Format Cells dialog box, click OK.

If Excel displays ##### in a cell after you apply currency formatting to your data, the cell probably isn't wide enough to display the data. To expand the column width, double-click the right boundary of the column that contains the cells with the ##### error. This automatically resizes the column to fit the number. You can also drag the right boundary until the columns are the size that you want.

Column boundary being dragged

Top of Page

Remove currency formatting

If you want to remove the currency formatting, you can follow these steps to reset the number format.

  1. Select the cells that have currency formatting applied to them.

  2. On the Home tab, in the Number group, click General.

    Cells that are formatted with the General format do not have a specific number format.

Top of Page

Create a workbook template with specific currency formatting settings

If you often use currency formatting in your workbooks, you can save time by creating a workbook that includes specific currency formatting settings, and then saving that workbook as a template. You can then use this template to create other workbooks.

Create the template

  1. Create a new workbook.

  2. Select the worksheet or worksheets for which you want to change the default number formatting.

    How to select worksheets

    To select

    Do this

    A single sheet

    Click the sheet tab.

    Active sheet tab

    If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.

    Tab scrolling buttons

    Two or more adjacent sheets

    Click the tab for the first sheet. Then hold down SHIFT while you click the tab for the last sheet that you want to select.

    Two or more nonadjacent sheets

    Click the tab for the first sheet. Then hold down CTRL while you click the tabs of the other sheets that you want to select.

    All sheets in a workbook

    Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

    Tip    When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

  3. Select the specific cells or columns you want to format, and then apply currency formatting to them.

  4. Make any other customizations you like to the workbook.

  5. Click the File tab.

  6. Click Save As.

  7. In the File name box, type the name that you want to use for the template.

  8. In the Save as type box, click Excel Template, or click Excel Macro-Enabled Template if the workbook contains macros that you want to make available in the template.

  9. Click Save.

  10. Close the template.

Create a new workbook based on the template

  1. Click the File tab.

  2. Click New.

  3. Click My Templates.

  4. In the New dialog box, double-click the template you just created.

    Excel creates a new workbook that is based on your template.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×