You can select whichever option you prefer.
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. The steps below will show you how to adjust the formatting of a group of cells that you have selected. Our short tutorial below will show you how to select cells and format them to automatically add parentheses around any negative number.Īutomatically Add Parentheses Around Negative Numbers in Excel 2010 Fortunately Excel 2010 has a formatting option that will automatically place parentheses around negative numbers, which can make them easier to locate.īut this formatting is typically not applied by default, so you will need to add it yourself. 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. 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.
