How do you format a percentage in brackets (3.40%) vs. -3.40%

To format a percentage in brackets in Microsoft Excel, follow these steps:

1. Select the cell or range of cells that you want to format.
2. Right-click on the selected cells and choose "Format Cells" from the context menu.
3. In the Format Cells dialog box, select the "Custom" category.
4. In the "Type" field, enter the following format code:
   Code:

   0.00%;(0.00%)

5. Click "OK" to apply the formatting.

Note: You can adjust the number of decimal places by changing the number of zeros after the decimal point in the format code. For example, if you want to display percentages with one decimal place, use the format code .

Go to Format Cells, go to custom:

0.00%;(0.00%)

and, if you want negative to show in red:

0.00%;[Red](0.00%)


"Jim" wrote:

How do you format a percentage in brackets (3.40%) vs. -3.40%