How to Add Parentheses in Excel

Microsoft Excel is a powerful tool that allows users to perform a variety of calculations and operations quickly and easily. One commonly used feature is adding and using parentheses in formulas. Parentheses are used to clarify the order of operations and guarantee the accuracy of the calculations. In this article, we will explain how to add parentheses in Excel and provide some practical examples to help you master this essential formula-building technique. Whether you’re a beginner or a seasoned Excel user, this guide will help you streamline your calculations and improve your productivity.

Quick answer

To add literal parentheses around a value in Excel, use a formula that joins the brackets to the cell, such as ="("&A1&")" or =CONCAT("(",A1,")"). To display negative numbers in parentheses instead, don’t change the value at all — apply a number format through Format Cells → Number → Negative numbers, or use a custom format like #,##0;(#,##0).

There are two very different tasks people mean by “adding parentheses,” and it’s worth being clear which one you need:

• Adding parenthesis characters to text or numbers, so a cell that reads Apple becomes (Apple). This changes the actual contents and is done with a formula.
• Formatting negative numbers in parentheses, so -1500 displays as (1,500) while still holding the value -1500 for calculations. This changes only how the number looks and is done with cell formatting.

The sections below cover all three: using parentheses inside formulas (order of operations), wrapping values in literal brackets, and displaying negatives in parentheses.

What are parentheses in Excel?

Parentheses are used in Excel formulas to tell the program what calculations to execute first. If you’ve ever used PEMDAS, or Please Excuse My Dear Aunt Sally, then you’ll be familiar with the order of operations. Parentheses allow you to enforce that order of operations and ensure that your formulas are calculating the way you want them to. They’re an essential tool for anyone who uses Excel regularly.

Adding Parentheses Using Formulas

To add parentheses in Excel, you can use the SUM function. To do this, follow these simple steps:

Step 1: Open your Excel workbook

Open the workbook you want to use in Excel.

Step 2: Enter your formula

Enter the formula you want to use in a cell. For example, “(2+2)*3”.

Step 3: Add parentheses

To add parentheses, simply place them around the portion of the formula you want to calculate first. For example, if you want to calculate the sum of 2+2 before multiplying by 3, you would add parentheses around 2+2. Your formula would look like: “=(2+2)*3”.

Step 4: Complete the formula and press enter

Complete the formula as normal, and press Enter. Excel will calculate the formula according to the order of operations, starting with the expressions in parentheses.

Adding Parentheses Using the Formula Bar

Another way to add parentheses is by using the formula bar. Here’s how:

Step 1: Select the cell with the formula

Select the cell that contains the formula you want to modify.

Step 2: Click on the formula bar

Click on the formula bar at the top of the spreadsheet.

Step 3: Add the parentheses

To add parentheses, place your cursor where you want to add them and type them in. For example, if you want to calculate the sum of 2+2 before multiplying by 3, you would add parentheses around 2+2. Your formula would look like: “=(2+2)*3”.

Step 4: Complete the formula and press Enter

Complete the formula as normal, and press Enter. Excel will calculate the formula according to the order of operations, starting with the expressions in parentheses.

Adding parentheses to your Excel formulas is a simple way to ensure that your calculations are accurate and efficient. Whether you’re a beginner or an advanced user, mastering the use of parentheses in Excel will help you to streamline your calculations and improve your productivity. Try using parentheses in some of your more complex formulas, and see how much more efficient your work becomes!

Putting Parentheses Around Text or Numbers in a Cell

The steps above use parentheses to control math. But a very common request is different: you want a cell to literally show its value wrapped in brackets, turning Smith into (Smith) or 2024 into (2024). Because parentheses aren’t part of the stored value, you build the result with a formula that joins the brackets to your data.

The simplest approach uses the ampersand (&) operator to concatenate the pieces. If your value is in cell A1, enter this in a blank cell:

="("&A1&")"

Excel reads this as: the text (, then whatever is in A1, then the text ). If A1 contains Apple, the result is (Apple).

You can do exactly the same thing with the CONCAT function, which many people find easier to read:

=CONCAT("(",A1,")")

Both formulas return the identical result, so use whichever you prefer. The CONCAT and ampersand methods are also covered in our guide on how to combine cells in Excel, and you can extend the same idea with other Excel text functions when you need to trim, pad, or reformat the value before wrapping it.

A few things to keep in mind:

• The result is text, even when the original was a number. A cell showing (2024) built this way can no longer be used in arithmetic.
• The brackets, like any literal text in a formula, must be wrapped in double quotation marks: "(" and ")". The same quoting rule applies when you add single quotes or any other literal characters around a value.
• If you only want the display to change and the value to remain usable in calculations, you almost certainly want number formatting instead — see the next section.

Adding parentheses to a whole column

Once your formula works in one cell, applying it down an entire column takes seconds with the fill handle:

1. Click the cell that contains your ="("&A1&")" formula to select it.
2. Hover over the small green square in the bottom-right corner of the cell — the cursor turns into a thin black cross (the fill handle).
3. Double-click that square to fill the formula down automatically to the bottom of the adjacent data, or click and drag it down as far as you need.

Because A1 is a relative reference, Excel adjusts it for each row (A2, A3, A4, and so on), so every cell gets wrapped in parentheses against its own neighbor. If you’d rather keep the wrapped values as fixed text, copy the formula column and use Paste Special → Values to replace the formulas with their results.

Showing Negative Numbers in Parentheses

In accounting and finance, negatives are traditionally shown in parentheses — (1,500) rather than -1500. This is a formatting change, not a formula. The cell still holds the negative value -1500 so it works correctly in sums and other calculations; only its appearance changes.

Method 1: Format Cells → Number → Negative numbers

This is the built-in option and the easiest place to start:

1. Select the cell or range you want to format.
2. Press Ctrl + 1 (or right-click and choose Format Cells) to open the Format Cells dialog.
3. On the Number tab, choose Number in the Category list.
4. In the Negative numbers box, pick one of the parentheses options — (1,234) for plain parentheses or (1,234) in red for parentheses plus red color.
5. Set the decimal places and the Use 1000 Separator (,) checkbox to taste, then click OK.

Any negative value in that range will now display inside parentheses, while positives display normally. For more on this dialog, see our walkthrough of how to format cells in Excel.

Method 2: A custom number format

If you want exact control — for example, parentheses with no decimal places and a thousands separator — use a custom format. A number format in Excel has up to four sections separated by semicolons: positive; negative; zero; text. You only need the first two here:

#,##0;(#,##0)

The part before the semicolon formats positive numbers, and the part after it formats negatives. Because the negative section already adds its own parentheses, Excel does not show the minus sign. To apply it:

1. Select your range and press Ctrl + 1 to open Format Cells.
2. On the Number tab, choose Custom.
3. Type #,##0;(#,##0) into the Type box and click OK.

To make negatives red as well, add a color code to the negative section: #,##0;[Red](#,##0). You can read more about that effect in how to make negative numbers red in Excel.

Method 3: The Accounting format

Excel’s built-in Accounting number format (the $ button in the Number group on the Home tab, or the Accounting category in Format Cells) automatically shows negatives in parentheses and aligns currency symbols and decimal points in a column. It’s the fastest choice when you’re working with money and want negatives in parentheses without building a custom string.

Remember that all three methods only change the display. The underlying value stays negative, which is exactly what you want — you can still convert a negative number to positive with a formula like =ABS(A1) whenever you actually need to change the value rather than its appearance.

Cases when parentheses are necessary

Parentheses are necessary when you have multiple operators within a formula, like addition, subtraction, multiplication and division, because without them, Excel will follow the standard order of operations. For instance, a formula that reads 3 + 2 * 4 will result in 11 because multiplication has a higher priority than addition. You can solve this problem by adding parentheses around the addition operation: (3 + 2) * 4. By using parentheses, the result will now be 20, because Excel will calculate the addition operation first.

Using Nested Parentheses

Nested parentheses are when you use two or more sets of parentheses within a formula, allowing you to create more complex equations with multiple operations. When using nesting, it is important to remember to close each of the parentheses in the correct order. An example of a nested parentheses formula is “=(1+(2*3))/4”. In this formula, the multiplication operation within the parentheses must be completed first, then the addition outside of the parentheses, and finally the division operation outside of all the parentheses.

Common Mistakes with Parentheses

One common mistake when adding parentheses in Excel is accidentally putting the wrong operation inside the parentheses. This will result in an incorrect calculation. Another common mistake is not adding enough parentheses, which can also lead to an incorrect calculation. Always double-check your formulas for accuracy before entering them into your spreadsheet.

Adding parentheses is a crucial part of using Excel. Using them in your formulas can help to clarify the order of operations and ensure that your calculations are accurate. Whether you’re a beginner or an advanced user, mastering the use of parentheses in Excel will make you a more efficient and effective spreadsheet user.

Frequently Asked Questions

How do I put parentheses around text or a number in Excel?

Use a formula that joins the brackets to your value, such as ="("&A1&")" or =CONCAT("(",A1,")"). If A1 contains Apple, both formulas return (Apple). The result is text, so it can no longer be used directly in calculations.

How do I show negative numbers in parentheses in Excel?

Select your range, press Ctrl + 1, and on the Number tab choose Number, then pick a parentheses option under Negative numbers. Alternatively, apply a custom format of #,##0;(#,##0). This only changes how the value displays — the number stays negative for calculations.

What’s the difference between adding parenthesis characters and formatting negatives in parentheses?

Adding parenthesis characters with a formula changes the actual contents of the cell and produces text. Formatting negatives in parentheses changes only the display while the cell keeps its numeric value, so it still works in sums and other math.

How do I add parentheses to an entire column at once?

Enter your wrapping formula in the first cell, then double-click the fill handle (the small square at the cell’s bottom-right corner) to copy it down the column. Because the reference is relative, each row wraps its own value.

Why doesn’t a minus sign appear when I use the (#,##0) custom format?

The negative section of the format, the part after the semicolon, already supplies its own parentheses to indicate a negative value, so Excel omits the minus sign. The value itself is unchanged and still negative.

Can parentheses be used to change the order of operations in Excel?

Yes. By placing expressions within parentheses, you force Excel to calculate those expressions first before moving on to other portions of the formula, overriding the standard PEMDAS order.