This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Cell Formatting - Show Negative Dollar Values in Parenthesis

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.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Cell Formatting - Show Negative Dollar Values in Parenthesis.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.