Forum Discussion

Copper Contributor

Feb 22, 2021

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 appreciated.

Thanks

Sridhar Dasari

JMB17
Feb 22, 2021
Sridhar0311

You could try a custom number format: 0.00;(0.00)

4 Replies

JMB17
Bronze Contributor
Feb 22, 2021
Sridhar0311

You could try a custom number format: 0.00;(0.00)
- Sridhar0311
  Copper Contributor
  Mar 05, 2021
  I tried this before but it is coming like -(9000). But i need only (9000)
  - JMB17
    Bronze Contributor
    Mar 05, 2021
    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.