Displaying Numbers in Excel 2007 as Currency

Many Excel 2007 worksheets include financial data, so you’ll likely use either the Currency or Accounting number formats when working with this data. You can easily assign these formats to selected cells by choosing Currency or Accounting from the Number Format drop-down list in the Number group on the Home tab. Use the Format Cells dialog box to specify other related options.

Both the Currency and Accounting number formats add a currency symbol, use commas to separate thousands, and display two decimal places. Here’s where these two formats differ:

Currency format: Displays the currency symbol immediately to the left of the number and displays a minus sign in front of negative values.

Accounting format: Displays the currency symbol at the left edge of the cell, lines up the decimal points in a column, and encloses negative values within parentheses (the way accountants like them). Also indents numbers slightly from the right edge of the cell to accommodate the right parenthesis in negative values.

Use the Accounting Number Format button in the Number group to quickly format the cell selection using the Accounting number format. Click the Accounting Number Format drop-down button to display a menu of other major currency number formats from which you can choose.

Follow these steps to format numbers in Excel 2007 as currency:

Select the cells containing the numbers you want to format.

From the Home tab, click the Number dialog box launcher in the bottom-right corner of the Number group.

The Format Cells dialog box appears, with the Number tab on top.

In the Category list, select Currency or Accounting.

These two formats display currency values a bit differently, as explained above.

Use the Format Cells dialog box to apply Currency and Accounting formats.

Change any other options as desired, such as the number of decimal places or the symbol to use for currency.

The Accounting format also enables you to choose different ways to display negative values.

Click OK.

Use the Accounting Number Format button on the Home tab to quickly apply the Accounting format to worksheet totals.

Dummies Insider

Sign up for insider news on books, authors, discounts and more content created just for you.