Forum Discussion
Solved
How to show negitive value with brackets
Hi All, I want to know that is there any possibility to show negative value in a Excel cell, that need to be shown with in brackets. Requirement as shown below. Any insights are highly ...
- I tried this before but it is coming like -(9000). But i need only (9000)
- I would guess that you used: 0.00;-(0.00)
Which is not what I suggested. Since my previous post included a screenshot showing the negative result formatted exactly as you requested, and not -(9000) as you say, I'm not sure why you don't believe it would work. - In that case, you have made a mistake implementing the the second term of the number format. Less importantly, I would suggest adding a space after the positive numbers to align the positive and negative numbers. Colour can also be used.
0.00_);[RED](0.00);;@
