How to Put Parentheses Around Negative Numbers in Excel 2010

When you are working with a lot of data in Microsoft Excel 2010, it is often beneficial to format certain types of data so that they stand out.

If, for example, you have a spreadsheet that tracks balances of accounts, then you may be most interested in the accounts that have a negative balance.

Fortunately, Excel 2010 has a formatting option that will automatically place parentheses around negative numbers, which can make them easier to locate.

But this formatting is typically not applied by default, so you will need to add it yourself. Our short tutorial below will show you how to select cells and format them to automatically add parentheses around any negative number.

Automatically Add Parentheses Around Negative Numbers in Excel 2010

The steps below will show you how to adjust the formatting of a group of cells that you have selected. You will actually have two options to achieve the desired behavior; one option is for black numbers with parentheses, and the other option is for red numbers with parentheses. You can select whichever option you prefer.

Step 1: Open your file in Excel 2010.

Step 2: Use your mouse to select the cells to which you wish to apply this formatting. You can click a column letter or row number to select that entire column or row, or you can read this article to learn how to select all of the cells in the spreadsheet.

select the cells

Step 3: Right-click on one of the selected cells, then click the Format Cells option.

click format cells from shortcut menu

Step 4: Click the Number or Currency option at the left side of the window, depending upon the type of data you are working with.

click number or currency

Step 5: Click your preferred formatting option under Negative numbers.

select preferred bracket formatting

Step 6: Click the OK button at the bottom of the window to apply your changes.

click the OK button

If you are unable to right-click in Step 3 above, then you can also access the Format Cells window by clicking the Home tab at the top of the window

click the Home tab

Then clicking the Format button in the Cells section of the navigational ribbon and selecting the Format Cells option. You can then continue with Steps 4 – 6 above.

click format cells

Now that you know how to put parentheses around negative numbers in Excel 2010, you can use this formatting to make negative numbers easier to identify in your spreadsheets.

Is there a lot of unusual formatting in your spreadsheet, but you are unsure of how to remove it? This article will show you how to clear formatting from selected cells.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy