How to Display Negative Numbers in Red or With Parentheses in Excel

You may have financial data where negative values need to stand out. Excel can automatically format these numbers for better readability. This is controlled by the cell’s number format code. This article explains how to apply and customize formats to show negatives in red or inside parentheses.

Understanding Excel’s Number Formatting for Negatives

Excel stores the actual value of a number separately from how it is displayed. The display is governed by a number format. Built-in formats for accounting and currency often include rules for negative numbers. You can also write custom format codes. These codes have up to four sections separated by semicolons: positive numbers; negative numbers; zero values; text. To format negatives, you modify the second section of the code.

Built-in vs. Custom Formats

Built-in formats are quick to apply but offer limited style combinations. For example, a built-in format might show negatives in red but without parentheses. A custom format gives you full control. You can combine parentheses, a red color, and even a minus sign in any order you choose.

Steps to Format Negative Numbers

Method 1: Use a Built-in Number Format

1. Select your cells
   Click and drag to select the cell range containing your numbers.
2. Open the Format Cells dialog
   Press Ctrl+1 on your keyboard. Alternatively, right-click the selection and choose Format Cells.
3. Choose a number category
   In the dialog box, click the Number tab. Select either Number or Currency from the Category list.
4. Select a format for negatives
   Look at the Negative numbers list in the right pane. Click an option that shows parentheses, a red color, or both. Click OK to apply.

Method 2: Create a Custom Number Format

1. Open the Format Cells dialog
   Select your cells and press Ctrl+1.
2. Go to the Custom category
   Click Custom in the Category list on the left.
3. Edit the Type field
   In the Type box, you will see the current format code. A common code for accounting is _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_). To create a simple format showing negatives in red with parentheses, type: #,##0.00;[Red](#,##0.00). The text [Red] before the second section applies the color.
4. Apply the format
   Click OK. All negative numbers in the selected range will now display according to your custom code.

Method 3: Use Conditional Formatting for Color Only

1. Select your cell range
   Highlight the cells you want to format.
2. Open the Conditional Formatting menu
   Go to the Home tab on the ribbon. In the Styles group, click Conditional Formatting.
3. Create a new rule
   Point to Highlight Cell Rules, then choose Less Than.
4. Set the rule parameters
   In the dialog box, type 0 in the field. Use the dropdown menu next to it to select Red Text or a custom format with red font. Click OK.

Common Formatting Mistakes and Limitations

Custom Format Does Not Apply to New Cells

Custom number formats are a property of the cell. If you type a new number into a formatted cell, it will use the format. However, if you insert a new row or column, the new cells may have the default General format. You must copy the format to the new cells using Format Painter or by applying the style again.

Parentheses Appear but the Number is Not Negative

This happens if you apply an Accounting format to a positive number. The Accounting format aligns the currency symbol and decimal points, which can use parentheses for visual spacing. Check the actual cell value in the formula bar. To show parentheses only for negatives, use a Custom number format like #,##0_);(#,##0).

Negative Numbers in Red Do Not Print in Color

This is usually a printer setting. Ensure your printer is set to print in color. Also, check Excel’s page setup: go to File > Print > Page Setup > Sheet tab, and verify the Black and white checkbox is not selected.

Built-in Formats vs. Custom Code: Key Differences

Item	Built-in Number Formats	Custom Number Format Code
Access Method	Format Cells > Number/Currency/Accounting category	Format Cells > Custom category
Flexibility	Limited to predefined style combinations	Full control over color, symbols, and structure
Color Application	Uses the [Red] color index only	Can use [Color X] where X is a color index number
Persistence	Format stays if you change the category later	Code is saved with the workbook and travels with copied cells
Best For	Quick, standard financial reporting	Specialized display requirements and template creation

You can now make negative values clearly visible using red text or parentheses. Use the built-in formats for speed on standard reports. Explore custom format codes when you need a specific presentation style. For a related technique, try using the Accounting format to align currency symbols and decimal points consistently across a column.