Hi, this is Gary with MacMost Now. In today's episode, let's look at formatting cells in iWork Numbers. So, here I am in Numbers, and I've got a cell here with a number in it. Now I want to add some formatting to it. One of the most basic examples is making forced decimal places. So, for instance, instead of seeing 4, see 4.0. If the next number is 5.7, you can see how I've got two different formats here; it'd be nice to have them be about the same. So, I can do that in the toolbar here. If you don't see the formatting toolbar, you can go to view and hide and show format bar. Now, if I have that cell selected, I can use these buttons here to simply add more decimal places that are automatically there even if they're zeros, or take them away. And you can see I can even do that here on this cell below, I can take it away, and it'll round it from 5.7 to 6. If I want to have it be uniform for the entire column, I can select the column, and I can use those buttons there. Now, I also have some easier format buttons right there; for instance, if I wanted to format these numbers as currency, I click on the dollar sign there, and it does that. Um, I can then go and do it as a percentage if I want. I also have a pull-down menu with a bunch of different options here. For instance, I can even do fractions. I can slide fractions and say, uh, go up to just one digit of fractions, and you can see it actually puts 5 5/7 there and I can add a new number now that's been formatted like that. So let's say if I do 7.5, I can see it formats it, shows it as 7 1/2. Now, in addition to using this little pull-down menu here, I can also go to view, show inspector, and that'll bring up the inspector here, and I can look at cell format, and I get the same options here, sometimes* it's just easier to use it in Inspector. So, I can change to different things here. For instance, I can go to Duration and have it set for hours. So, uh, the 7.5 becomes 7 hours and 30 minutes. I can slide this along here and actually change that if that was supposed to be, uh, if I wanted that to be formatted in minutes, seconds, or days, or even weeks. I have a lot of different options there. You can pull down - change the format completely to something like that. One interesting one here is I can change numerical systems, so I can actually go, say, to another base, like, for instance, I can go to base 16, press the decimal. If I enter in a number like 42, I can see that changes to 2A. There. And I can go down and change to base 2 for binary. Under currency, here, I've got a lot more options. I can choose the symbol, the number of decimal places, uh, choose to have it conditionally changed to red if it's a negative number. So, for instance, if I enter in here, -9, see it does it like that, and I've got the ability to add thousands separators as well, uh, do it in accounting style with the dollar sign all the way over there on the left. You can also set formatting for dates, uh, so I have a list of dates here - go to date and time, and I can choose from one of these many different date formats here, depending upon what I want. One cool thing you can do is you can choose a cell, and you can set the format to a stepper, or a slider. So, a stepper, I can give a minimum, maximum, and increment. And a way to display it as a general format there, and when I'm done, if I go over to this one here, instead of - see, I can just edit the number here, here I don't edit, I actually would go up or down using these arrow keys. Likewise, if I change it to a slider, I get the same controls here, but if I wanted to actually change the value, I can actually slide it up and down. That slider only appears when I've selected that number. It's very useful if you're making spreadsheets, uh, so you can do computations and you want to be able to play with some of the numbers. Another thing you can do is select a cell and set several values to appear in a popup menu. So, for instance, here's just, uh, 1, 2, 3, let's change that to, uh, 10, 20, 30, so, perhaps there are several different ways you can represent a number. You can add more, so we'll add 40, and then when I've selected this cell here, I can actually choose one of these values. Now, let's take a look at something called conditional formatting. An example, we've got four numbers here and the total there, the sum of these four numbers. Suppose maybe this is receivables, payables, and I want to get kind of an alert there, we can put this being red and in bold when it's a negative number and being in green when it's a positive number. So, let me select it, and under cell format I can click conditional format, show rules, and it brings up this dialogue right here. Now, I can choose a rule, and what I'm going to choose in this case is if it's less than 0, then I'm going to edit the rule here,set the text to red, bold, and done, and I can see it's a negative number there. So what happens if I were to change a number like this 99 to 101, and now it's a positive number; you can see that it isn't red. Now, I can add an additional rule here - select that cell, add another one, and say if it's greater than or equal to 0, then it's not going to be bold, it's just going to be a green color. So now when I change the number here, make it a positive result, you can see conditional formatting changes that cell automatically. You can also use conditional formatting on a variety of other things, like for instance in this column how I listed dates, I can choose a rule that if the date is in the, say, last 7 days, then change the text to purple, and done. You can see that those last two days which are in the last seven days are purple, and you can change it to be if it's in the next seven days, do the same thing. So, I end up basically with the dates being highlighted depending on how close they are to today's date. Now, if I close this spreadsheet and open it up again a week later, you'll* actually show me different dates highlighted here, so I can kind of create a chart that always highlights the dates that are closer to the ones that are today.
Related Posts: Using the Numbers Convert Function