SOLVED

How to show negitive value with brackets

%3CLINGO-SUB%20id%3D%22lingo-sub-2154880%22%20slang%3D%22en-US%22%3EHow%20to%20show%20negitive%20value%20with%20brackets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2154880%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20know%20that%20is%20there%20any%20possibility%20to%20show%20negative%20value%20in%20a%20Excel%20cell%2C%20that%20need%20to%20be%20shown%20with%20in%20brackets.%20Requirement%20as%20shown%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sridhar0311_0-1613977265493.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256436i382F347B63D2684E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sridhar0311_0-1613977265493.png%22%20alt%3D%22Sridhar0311_0-1613977265493.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAny%20insights%20are%20highly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESridhar%20Dasari%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2154880%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2155049%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20show%20negitive%20value%20with%20brackets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155049%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F855888%22%20target%3D%22_blank%22%3E%40Sridhar0311%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20try%20a%20custom%20number%20format%3A%26nbsp%3B0.00%3B(0.00)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JMB17_1-1613981381079.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256443i20D47B0360C448E0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JMB17_1-1613981381079.png%22%20alt%3D%22JMB17_1-1613981381079.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2187065%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20show%20negitive%20value%20with%20brackets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2187065%22%20slang%3D%22en-US%22%3EI%20tried%20this%20before%20but%20it%20is%20coming%20like%20-(9000).%20But%20i%20need%20only%20(9000)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2187329%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20show%20negitive%20value%20with%20brackets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2187329%22%20slang%3D%22en-US%22%3EIn%20that%20case%2C%20you%20have%20made%20a%20mistake%20implementing%20the%20the%20second%20term%20of%20the%20number%20format.%20Less%20importantly%2C%20I%20would%20suggest%20adding%20a%20space%20after%20the%20positive%20numbers%20to%20align%20the%20positive%20and%20negative%20numbers.%20Colour%20can%20also%20be%20used.%3CBR%20%2F%3E0.00_)%3B%5BRED%5D(0.00)%3B%3B%40%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

 

Sridhar0311_0-1613977265493.png

Any insights are highly appreciated.

 

Thanks

Sridhar Dasari

 

4 Replies
best response confirmed by Sridhar0311 (Occasional Contributor)
Solution

@Sridhar0311 

 

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

 

JMB17_1-1613981381079.png

 

 

 

I tried this before but it is coming like -(9000). But i need only (9000)
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);;@
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.