Microsoft Excel 2007 with Example

4 Format Cells:

4.2 Format Cells: Currency vs Accounting

The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference.

1. Enter the following values.

General Format

2. The Currency format places the dollar sign right next to the number.

Currency Format

3. The Accounting format aligns the dollar signs at the left edge of the cell and displays a dash for zero values.

Accounting Format

Note: the Currency format can display negative numbers with a minus sign, in red, with parentheses, or in red with parentheses. The Accounting format displays negative numbers in parentheses.