Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Formula result in brackets

0

Can anyone help with a simple way to show a formula result in brackets

Answer
Discuss

Answers

0
Selected Answer

JonP

Assuming the formula result is numeric, you could set a Custom cell format to show negative values within brackets (rather than -42 say). With the cell (or cells) selected, right click, pick Format Cells... then Custom and paste this into the Type: box:

#,##0.00;(#,##0.00)
where the bit in bold is how negative number shows, in this case to 2 decimal places (with the thousands separator) and within parentheses.

Note that the cell value remains -42 say so can be used in calculations.

If you want to show only negative percentages within brackets, use this Custom format instead:

0.00%;(0.00%)

Hope this helps.

Discuss

Discussion

John, thanks for the answer but the cell is already formatted to be a percentage.  Is there a way to format as you show and percentage as well?
For information, the formula is as simple as =C23/C33
JonP (rep: 35) Jan 11, '22 at 10:21 am
JonP- please see revised Answer
John_Ru (rep: 2867) Jan 11, '22 at 10:58 am
Thanks John
JonP (rep: 35) Jan 11, '22 at 11:14 am
Glad it worked for you JonP. Thanks for selecting my Answer.
John_Ru (rep: 2867) Jan 11, '22 at 11:18 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login