Get instant live expert help on I need help with excel negative numbers in brackets

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi i need the custom format for display of numbers in lakhs with two decimals and negative numbers in brackets. for eg -123456789.00 to be displayed as (1,234.57). Can this be provided
Solved by B. S. in 11 mins
How do add numbers in a column but exclude those in brackets ie 133 (29) + 163 (76) + 13 (74) = Or ideally add the numbers outside the brackets and separately those inside the brackets), therefore total would look like = 309 (179)
Solved by K. F. in 24 mins
I'm building a profit and loss account. I want a column of positive figures to add up to a negative figure (in brackets). Its a column of expenditure but i dont want to have to enter numbers as minus each time
Solved by Z. J. in 27 mins
It is an urgent matter so please if anyone can solve this How to set that if the number in the cell is negative to be displayed in brackets no matter how many digits it has? (-1,34) (-3) (-1,6789) 2 6,789. So if the number is positive it is displayed normally but negative in brackets. I tried #,###;(-#,###) but this gives (1,).
Solved by X. H. in 27 mins
How do you convert a - negative sign into ( ) brackets. I tried going into "Custom" but the drop down does not show ( )
Solved by T. E. in 11 mins