WEBVTT

0
00:01.650 --> 00:06.480
Okay guys now we're going to have a look at how to change the number of decimal places we can see in

1
00:06.480 --> 00:07.740
our results.

2
00:07.740 --> 00:14.190
You can see here currently in this range that we have a uniform amount of decimal places. But if we look

3
00:14.190 --> 00:15.850
over here at this data,

4
00:16.050 --> 00:18.450
we can see that we have varying different lengths.

5
00:18.450 --> 00:21.170
We have some that are this long some with just one.

6
00:21.360 --> 00:25.770
There are essentially two ways to change the number of decimal places you can see:

7
00:25.770 --> 00:31.050
The first is to hover over the cell that you want to change, make sure it's selected, right click and

8
00:31.050 --> 00:36.540
choose "Format Cells". And format cells will bring up this dialogue box, and you can see that "Number" is

9
00:36.540 --> 00:38.280
already selected.

10
00:38.280 --> 00:43.890
We have a sample data which is 6.8333, which is copied from

11
00:43.890 --> 00:48.630
this cell just here...and we can see that we have number of decimal places as 8.

12
00:48.630 --> 00:54.090
So if you want to increase it, just hit the little top arrow button and you can see in our sample that

13
00:54.090 --> 00:59.910
this increases. Or hit the down button and you can see our sample decreases the number. Alternatively, you can

14
00:59.910 --> 01:03.850
just highlight the number and type any number you want over it.

15
01:03.960 --> 01:06.560
So that's the one way to do it.

16
01:06.740 --> 01:07.070
Okay.

17
01:07.080 --> 01:10.170
The next way is to do it is to look at the "Home" ribbon.

18
01:10.230 --> 01:13.620
And we're going to look at the "Number" section of the home ribbon.

19
01:13.620 --> 01:19.430
Now here we can see that we have the "Increase Decimal" and the "Decrease Decimal"...

20
01:19.450 --> 01:21.090
And it's pretty obvious what they do.

21
01:21.150 --> 01:23.730
If you left click the increase decimal.

22
01:23.730 --> 01:27.600
You can see that our number is increasing by one decimal place for each click.

23
01:27.630 --> 01:33.570
And to decrease just hit the other button and it decreases by 1 each time. Now  can do this one at a

24
01:33.570 --> 01:35.960
time, or you can do them en masse.

25
01:36.000 --> 01:40.680
And this time we're going to do them all together. So I'm just going to bring up that format box, I'm going to select

26
01:40.680 --> 01:45.300
"Number", and I'm going to say let's just have it down to one decimal place.

27
01:45.330 --> 01:49.750
So I'm going to hit "OK", and there you go... now you can see our data looks much better.

28
01:49.810 --> 01:51.850
Let's delete those zeros off the bottom.

29
01:52.080 --> 01:56.870
So there you go... now you can see all our data is uniform, and it's displayed to one decimal place.

30
01:56.880 --> 01:58.160
Very simple indeed.

31
01:58.380 --> 02:02.310
Okay, in the next lecture we're going to have a look at something really interesting...

32
02:02.310 --> 02:07.650
We're going to have a look at how to build a complex formula by using some that you've already built

33
02:07.650 --> 02:08.530
beforehand.

34
02:08.590 --> 02:10.280
Okay see you in the next lecture.