00:00Let me ask you this question. Would you be able to find a negative number on this first data set
00:05or on the second one? If you have chosen the second data set and wish to know how to do it,
00:11let's get started. The first thing you have to do is to highlight the first cell on the first row
00:16like this and press ctrl 1 to open up cell formatting pop-up window. Make sure you're on
00:22the number tab and after that go to custom. We're going to scroll all the way up and then select
00:27this one here. In here, the first section, this one here, pertains to positive number and the one
00:35anything after the square bracket and red pertains to the negative number. Let me go back in there.
00:40So now to customize it, do what we want. We're going to deal with the positive number first. We're
00:46going to say dollar asterisk space. This asterisk allows you to get this kind of a gap between the
00:52dollar sign and the numeric value. For the negative number, we're going to get rid of the minus sign
00:57and do the same thing as dollar asterisk space. Then we're going to cover the negative number
01:04in parenthesis. Open parenthesis and go to the last one, last character as close parenthesis like
01:10this. Now if you hit OK, apply the same cell formatting to the rest of the row by going to
01:16Home, Clipboard, Format Painter and then select all the rows like this and you can see any negative number
01:24here. It has a font color of red and cover in parenthesis. Now this kind of solution is great for small data set.
01:34But what if you have multiple sheet like what I have here on my workbook or worse still, you have to apply the
01:39same cell formatting to multiple workbook. How would you do it? Well, you're going to have to do it on a system
01:46level here. Let me undo all these changes here like this and get back to where we were originally. Now first of all, we're going to
01:52launch windows setting by holding your windows key and pressing i. It will come up to the windows settings
01:57here. In here, you're going to select time and language and on this right hand side of the panel,
02:04you're going to select language and region. Click on here and then you're going to scroll all the way
02:09down until you see administrative language setting here. You're going to click on this icon here and
02:14you'll open a pop-up window here. In this pop-up window, you're going to select formats tab and then you're
02:20going to go all the way down and select additional settings here like this. Now you're going to go
02:25currency tab and change this formatting into parenthesis formatting like this. Now at this
02:33point, we are dealing with currency. If any currency value has negative, it's going to be in parenthesis
02:39like this. But if you're going to apply the same thing to a numeric value, you're going to go to the
02:43numbers tab and make the same changes here like this. But we're not dealing with numeric numbers at this
02:48point. We're just demonstrating on currency. But if you have to do a numeric value, you're going to
02:52go ahead and do this. Okay, I'm going to undo this guy here. Once that's done, once you make your
02:57currency changes to parenthesis for negative number, you're going to go OK twice like this, once, twice,
03:04and close your window setting like this. And you can see all the negative numbers are in parenthesis
03:12already here. You can see this one here, this one here, and this one here. Now to make the
03:16text or the font color red, you're going to highlight all the cell under the total sales here.
03:24And then you're going to go control one to open up a format cell. In here, you're going to go currency.
03:30And you can see now the currency have this option where you can select this red and parenthesis. You
03:35can select that guy and click OK. Those are the two techniques to displaying negative numbers in brackets,
03:41depending on your use case and application needs.
