Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Cell Formatting

Show Negative Dollar Values in Parenthesis

Summary: Many businesses want negative dollar amounts shown in parenthesis, not prefixed by minus signs. Perform this tweak with Excel 2003.

In some business environments, it may be desired to show negative dollar values not as numbers prefixed with a minus sign, such as -$1,291.11, but as numbers surrounded in parenthesis, such as ($1,291.11). To force Excel 2003 to display numbers this way for a particular cell or group of cells:

1. Right-click on a cell containing a possibly negative dollar amount, or select a group of cells containing dollar amounts, and choose "Format Cells".

2. When the "Format Cells" dialog box appears, click the "Number" tab.

3. Click "Currency" underneath "Category".

4. Under "Negative numbers", choose the ($1,234.10) option to show negative dollar amounts in parenthesis. You can also click the option in red to really make negative dollar amounts stand out.

5. Click "OK" to close the dialog box.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Cell Formatting page.

Print this tip.

- Subscribe!

Search the Site: