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

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