Show Negative Numbers in Red Color (with a Bracket) in Excel

[@jerrytai5714]

Thank you! It’s very useful!!! Big cheers!!! Very clear explanation 😊

[@renaldoschutte8065]

This was so useful, thank you for keeping it so simple.

[@yefaobeng4936]

Really useful the part when you explain how the formatting works. Thank you!

[@korolova21]

Thanks!!!

[@meetkcs]

Excellent, very nice option.
How you r exploring such a micro level options.
Wonderful.

[@at9124]

Explained very well, many thanks.

[@monisharaj2429]

Fantastic ... after 2hrs... i found it

[@himanshudalai1028]

Super useful. Thank you Sumit.

[@wayneedmondson1065]

Hi Sumit.. thanks for the video. Custom number formatting is so powerful and useful. Thanks for sharing your tips. Thumbs up!

[@BobbySamsel]

extremely helpful and thank you!

[@noufal8518]

Useful. Thank you . how can we add thousand separator comma in this format ?

[@JL-xu5vq]

Thank you !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@m.grohman2463]

Thanks so much !! Very helpful

[@marketwarket5030]

Amazing Boss

[@muhammadabdulrouf3353]

Very useful

[@shwetbabbu]

Great this helped me. Many thanks

[@HimanshuKumar-fr1mo]

Pls make video on how to apply sum, multiplY,divide formula on the cell contains TEXT..BTW ..all your videos are awesome!

[@shefalirana5658]

Useful.Thank you👍

[@Lychee76]

Thank you very much buddy. Obliged!!!

[@sportsmusiclover]

Thanks so much. But how do you remove the decimals from the numbers once you apply the 'GEneral;' custom addition?

[@angelicosdeep7127]

so useful thank you

[@josephmathieu2436]

Thank you!

[@filmyfreak5413]

Very helpful....thnk you

[@sachintompe5786]

thanks

[@davidoverington8576]

super, answer in 30 secs!!

[@valentinebalasubramaniam8454]

Thank you

[@umeshchandarana8415]

There are Dr. And Cr. I want all Cr. ( Credit ) to be shown as negative. How can I do so ? Please guide.

[@khalidQweder]

Excellent .

[@trumpexcel]

Glad you found the video useful!

[@AS-uz2gf]

Excellent Video. I need a doubt. How to append the decimals inside the bracket ie., (100.00), (200.00) etc., If I click comma (,) icon, (-200) convert into -200.00.

[@ummufaheemap2861]

Thank you so much

[@venkym8159]

Superb bro

[@mishraamukesh]

Exceptional

[@ancos26]

excellent

[@vishaleee404]

great tric bro keep it up

[@Krooless]

Thank you

[@Turnivor]

The thing is, i want to have the following format, but excel keeps excluding the - and places it OUTSIDE the brackets. How can i include the - INSIDE the brackets?
The end result should be like this: (-1.29%) for decreases and (2.15%) for increases

[@bheemappabellad161]

plz guide me how add the numbers out of bracket separately and within the bracket separately.
my data in a1, a2,a3 are given below. how can I get the dynamic answer 6(4) in a4 cell. plz explain.
ex: 2(1)+3(1)+1(2)=6(4)
thank u sir

[@ashoksahu9546]

Nice video sir.

[@divyaguru5474]

Bro this is ms excel 2019 or any other tell me plz

[@tajwarhashmi9050]

What about separators?

[@kimberleebillows4218]

Microsoft won't allow me to do this formula. It keeps stating to use a selected one below.

[@chinnu15227]

how to change the negative numbers to red in googlefinance

[@excelforeveryone2657]

Awesome

[@PintuKumar-fo3wh]

I want text instead of number how to apply formula

[@najmulhasanrashel]

Great

[@jamilhfl]

in 1000 number comma is not working

[@HDPicassoH]

[Green][$£-809]#,##0.00;[red]-[$£-809]#,#,##0.00 - - Green positive, Red negative currency numbers - If it helps.

[@saltadistribution5189]

wow

[@CineSlice149]

Thank you!

[@marketwarket5030]

Amazing Boss

[@PintuKumar-fo3wh]

Thank you