WEBVTT
Kind: captions
Language: en

00:00:01.180 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.180><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:07.990 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c><00:00:06.850><c> you</c><00:00:07.850><c> may</c>

00:00:07.990 --> 00:00:08.000 align:start position:0%
opportunities for a better life you may
 

00:00:08.000 --> 00:00:10.209 align:start position:0%
opportunities for a better life you may
have<00:00:08.179><c> already</c><00:00:08.419><c> noticed</c><00:00:08.959><c> that</c><00:00:09.499><c> Excel</c><00:00:10.039><c> allows</c>

00:00:10.209 --> 00:00:10.219 align:start position:0%
have already noticed that Excel allows
 

00:00:10.219 --> 00:00:12.369 align:start position:0%
have already noticed that Excel allows
you<00:00:10.549><c> to</c><00:00:10.639><c> type</c><00:00:10.910><c> just</c><00:00:11.150><c> about</c><00:00:11.660><c> anything</c><00:00:12.019><c> into</c>

00:00:12.369 --> 00:00:12.379 align:start position:0%
you to type just about anything into
 

00:00:12.379 --> 00:00:15.249 align:start position:0%
you to type just about anything into
your<00:00:12.499><c> worksheet</c><00:00:13.070><c> along</c><00:00:13.969><c> with</c><00:00:14.150><c> text</c><00:00:14.629><c> you</c><00:00:15.110><c> can</c>

00:00:15.249 --> 00:00:15.259 align:start position:0%
your worksheet along with text you can
 

00:00:15.259 --> 00:00:17.650 align:start position:0%
your worksheet along with text you can
use<00:00:15.440><c> many</c><00:00:15.709><c> different</c><00:00:15.829><c> kinds</c><00:00:16.640><c> of</c><00:00:16.699><c> numbers</c><00:00:16.939><c> such</c>

00:00:17.650 --> 00:00:17.660 align:start position:0%
use many different kinds of numbers such
 

00:00:17.660 --> 00:00:20.800 align:start position:0%
use many different kinds of numbers such
as<00:00:17.720><c> decimals</c><00:00:18.529><c> percentages</c><00:00:19.310><c> dollar</c><00:00:20.210><c> amounts</c>

00:00:20.800 --> 00:00:20.810 align:start position:0%
as decimals percentages dollar amounts
 

00:00:20.810 --> 00:00:24.910 align:start position:0%
as decimals percentages dollar amounts
dates<00:00:21.380><c> and</c><00:00:21.710><c> more</c><00:00:22.330><c> to</c><00:00:23.330><c> do</c><00:00:23.509><c> this</c><00:00:23.750><c> Excel</c><00:00:24.439><c> uses</c><00:00:24.890><c> a</c>

00:00:24.910 --> 00:00:24.920 align:start position:0%
dates and more to do this Excel uses a
 

00:00:24.920 --> 00:00:27.040 align:start position:0%
dates and more to do this Excel uses a
feature<00:00:25.160><c> called</c><00:00:25.550><c> number</c><00:00:26.029><c> formats</c><00:00:26.480><c> and</c><00:00:26.720><c> it's</c>

00:00:27.040 --> 00:00:27.050 align:start position:0%
feature called number formats and it's
 

00:00:27.050 --> 00:00:29.050 align:start position:0%
feature called number formats and it's
really<00:00:27.470><c> important</c><00:00:28.099><c> to</c><00:00:28.250><c> understand</c><00:00:28.759><c> how</c><00:00:28.910><c> they</c>

00:00:29.050 --> 00:00:29.060 align:start position:0%
really important to understand how they
 

00:00:29.060 --> 00:00:31.920 align:start position:0%
really important to understand how they
work<00:00:29.800><c> number</c><00:00:30.800><c> formats</c><00:00:31.369><c> to</c><00:00:31.519><c> tell</c><00:00:31.699><c> Excel</c>

00:00:31.920 --> 00:00:31.930 align:start position:0%
work number formats to tell Excel
 

00:00:31.930 --> 00:00:34.299 align:start position:0%
work number formats to tell Excel
exactly<00:00:32.930><c> what</c><00:00:33.110><c> type</c><00:00:33.350><c> of</c><00:00:33.379><c> data</c><00:00:33.739><c> you're</c><00:00:33.980><c> using</c>

00:00:34.299 --> 00:00:34.309 align:start position:0%
exactly what type of data you're using
 

00:00:34.309 --> 00:00:36.850 align:start position:0%
exactly what type of data you're using
when<00:00:35.239><c> you</c><00:00:35.360><c> enter</c><00:00:35.750><c> something</c><00:00:36.050><c> into</c><00:00:36.379><c> a</c><00:00:36.500><c> Cell</c>

00:00:36.850 --> 00:00:36.860 align:start position:0%
when you enter something into a Cell
 

00:00:36.860 --> 00:00:39.580 align:start position:0%
when you enter something into a Cell
Excel<00:00:37.760><c> will</c><00:00:37.910><c> try</c><00:00:38.120><c> to</c><00:00:38.180><c> apply</c><00:00:38.660><c> the</c><00:00:38.780><c> right</c><00:00:39.170><c> number</c>

00:00:39.580 --> 00:00:39.590 align:start position:0%
Excel will try to apply the right number
 

00:00:39.590 --> 00:00:43.240 align:start position:0%
Excel will try to apply the right number
format<00:00:39.980><c> automatically</c><00:00:41.170><c> for</c><00:00:42.170><c> example</c><00:00:42.680><c> watch</c>

00:00:43.240 --> 00:00:43.250 align:start position:0%
format automatically for example watch
 

00:00:43.250 --> 00:00:45.069 align:start position:0%
format automatically for example watch
what<00:00:43.460><c> happens</c><00:00:43.789><c> when</c><00:00:43.940><c> we</c><00:00:44.059><c> enter</c><00:00:44.360><c> a</c><00:00:44.390><c> calendar</c>

00:00:45.069 --> 00:00:45.079 align:start position:0%
what happens when we enter a calendar
 

00:00:45.079 --> 00:00:49.330 align:start position:0%
what happens when we enter a calendar
date<00:00:45.289><c> into</c><00:00:45.590><c> this</c><00:00:45.800><c> cell</c><00:00:46.129><c> such</c><00:00:46.850><c> as</c><00:00:46.879><c> 1</c><00:00:47.300><c> /</c><00:00:47.600><c> 1</c><00:00:48.050><c> /</c><00:00:48.379><c> 2015</c>

00:00:49.330 --> 00:00:49.340 align:start position:0%
date into this cell such as 1 / 1 / 2015
 

00:00:49.340 --> 00:00:52.840 align:start position:0%
date into this cell such as 1 / 1 / 2015
for<00:00:49.820><c> January</c><00:00:50.449><c> 1st</c><00:00:50.780><c> if</c><00:00:51.430><c> you</c><00:00:52.430><c> look</c><00:00:52.609><c> at</c><00:00:52.730><c> the</c>

00:00:52.840 --> 00:00:52.850 align:start position:0%
for January 1st if you look at the
 

00:00:52.850 --> 00:00:54.880 align:start position:0%
for January 1st if you look at the
number<00:00:53.180><c> format</c><00:00:53.600><c> drop-down</c><00:00:53.930><c> menu</c><00:00:54.440><c> on</c><00:00:54.469><c> the</c><00:00:54.680><c> Home</c>

00:00:54.880 --> 00:00:54.890 align:start position:0%
number format drop-down menu on the Home
 

00:00:54.890 --> 00:00:57.430 align:start position:0%
number format drop-down menu on the Home
tab<00:00:54.920><c> you'll</c><00:00:55.850><c> see</c><00:00:56.120><c> that</c><00:00:56.359><c> this</c><00:00:56.600><c> cell</c><00:00:56.899><c> is</c><00:00:56.930><c> now</c>

00:00:57.430 --> 00:00:57.440 align:start position:0%
tab you'll see that this cell is now
 

00:00:57.440 --> 00:01:00.520 align:start position:0%
tab you'll see that this cell is now
using<00:00:57.949><c> the</c><00:00:58.070><c> date</c><00:00:58.340><c> number</c><00:00:58.699><c> format</c><00:00:59.170><c> this</c><00:01:00.170><c> tells</c>

00:01:00.520 --> 00:01:00.530 align:start position:0%
using the date number format this tells
 

00:01:00.530 --> 00:01:02.349 align:start position:0%
using the date number format this tells
Excel<00:01:00.710><c> that</c><00:01:01.190><c> we're</c><00:01:01.340><c> working</c><00:01:01.489><c> with</c><00:01:01.820><c> a</c><00:01:01.850><c> calendar</c>

00:01:02.349 --> 00:01:02.359 align:start position:0%
Excel that we're working with a calendar
 

00:01:02.359 --> 00:01:04.630 align:start position:0%
Excel that we're working with a calendar
date<00:01:02.690><c> and</c><00:01:02.899><c> not</c><00:01:03.320><c> another</c><00:01:03.679><c> type</c><00:01:03.980><c> of</c><00:01:04.160><c> number</c><00:01:04.460><c> if</c>

00:01:04.630 --> 00:01:04.640 align:start position:0%
date and not another type of number if
 

00:01:04.640 --> 00:01:07.510 align:start position:0%
date and not another type of number if
you<00:01:05.630><c> click</c><00:01:05.840><c> the</c><00:01:05.990><c> drop</c><00:01:06.229><c> down</c><00:01:06.259><c> menu</c><00:01:06.890><c> you'll</c><00:01:07.430><c> see</c>

00:01:07.510 --> 00:01:07.520 align:start position:0%
you click the drop down menu you'll see
 

00:01:07.520 --> 00:01:09.039 align:start position:0%
you click the drop down menu you'll see
that<00:01:07.790><c> there</c><00:01:07.970><c> are</c><00:01:08.000><c> several</c><00:01:08.299><c> other</c><00:01:08.630><c> number</c>

00:01:09.039 --> 00:01:09.049 align:start position:0%
that there are several other number
 

00:01:09.049 --> 00:01:11.440 align:start position:0%
that there are several other number
formats<00:01:09.409><c> to</c><00:01:09.590><c> choose</c><00:01:09.619><c> from</c><00:01:09.970><c> the</c><00:01:10.970><c> general</c>

00:01:11.440 --> 00:01:11.450 align:start position:0%
formats to choose from the general
 

00:01:11.450 --> 00:01:14.080 align:start position:0%
formats to choose from the general
format<00:01:11.810><c> at</c><00:01:12.020><c> the</c><00:01:12.229><c> top</c><00:01:12.470><c> is</c><00:01:12.740><c> the</c><00:01:13.280><c> default</c><00:01:13.850><c> number</c>

00:01:14.080 --> 00:01:14.090 align:start position:0%
format at the top is the default number
 

00:01:14.090 --> 00:01:15.819 align:start position:0%
format at the top is the default number
format<00:01:14.689><c> for</c><00:01:14.930><c> every</c><00:01:15.320><c> cell</c><00:01:15.560><c> in</c><00:01:15.680><c> your</c>

00:01:15.819 --> 00:01:15.829 align:start position:0%
format for every cell in your
 

00:01:15.829 --> 00:01:18.429 align:start position:0%
format for every cell in your
spreadsheet<00:01:16.340><c> when</c><00:01:17.240><c> Excel</c><00:01:17.600><c> isn't</c><00:01:18.049><c> able</c><00:01:18.170><c> to</c>

00:01:18.429 --> 00:01:18.439 align:start position:0%
spreadsheet when Excel isn't able to
 

00:01:18.439 --> 00:01:20.740 align:start position:0%
spreadsheet when Excel isn't able to
guess<00:01:18.650><c> what</c><00:01:19.009><c> type</c><00:01:19.040><c> of</c><00:01:19.310><c> data</c><00:01:19.670><c> you're</c><00:01:19.939><c> using</c><00:01:20.210><c> it</c>

00:01:20.740 --> 00:01:20.750 align:start position:0%
guess what type of data you're using it
 

00:01:20.750 --> 00:01:22.450 align:start position:0%
guess what type of data you're using it
will<00:01:20.960><c> usually</c><00:01:21.200><c> just</c><00:01:21.439><c> leave</c><00:01:21.920><c> the</c><00:01:22.130><c> general</c>

00:01:22.450 --> 00:01:22.460 align:start position:0%
will usually just leave the general
 

00:01:22.460 --> 00:01:25.420 align:start position:0%
will usually just leave the general
number<00:01:22.790><c> format</c><00:01:22.820><c> apply</c><00:01:23.689><c> to</c><00:01:23.750><c> that</c><00:01:24.049><c> cell</c><00:01:24.430><c> you</c>

00:01:25.420 --> 00:01:25.430 align:start position:0%
number format apply to that cell you
 

00:01:25.430 --> 00:01:27.910 align:start position:0%
number format apply to that cell you
know<00:01:25.610><c> in</c><00:01:25.820><c> this</c><00:01:26.180><c> example</c><00:01:26.600><c> I</c><00:01:26.960><c> think</c><00:01:27.439><c> I'd</c><00:01:27.560><c> like</c><00:01:27.740><c> to</c>

00:01:27.910 --> 00:01:27.920 align:start position:0%
know in this example I think I'd like to
 

00:01:27.920 --> 00:01:30.190 align:start position:0%
know in this example I think I'd like to
modify<00:01:28.460><c> the</c><00:01:28.520><c> number</c><00:01:28.939><c> format</c><00:01:29.360><c> to</c><00:01:29.600><c> use</c><00:01:29.780><c> the</c><00:01:29.960><c> long</c>

00:01:30.190 --> 00:01:30.200 align:start position:0%
modify the number format to use the long
 

00:01:30.200 --> 00:01:33.039 align:start position:0%
modify the number format to use the long
date<00:01:30.470><c> option</c><00:01:30.920><c> instead</c><00:01:31.310><c> that</c><00:01:32.299><c> way</c><00:01:32.540><c> it'll</c><00:01:32.930><c> be</c>

00:01:33.039 --> 00:01:33.049 align:start position:0%
date option instead that way it'll be
 

00:01:33.049 --> 00:01:35.880 align:start position:0%
date option instead that way it'll be
easier<00:01:33.530><c> to</c><00:01:33.710><c> read</c><00:01:33.950><c> in</c><00:01:34.100><c> our</c><00:01:34.220><c> spreadsheet</c>

00:01:35.880 --> 00:01:35.890 align:start position:0%
easier to read in our spreadsheet
 

00:01:35.890 --> 00:01:38.820 align:start position:0%
easier to read in our spreadsheet
and<00:01:35.979><c> there</c><00:01:36.580><c> we</c><00:01:36.700><c> go</c><00:01:36.960><c> when</c><00:01:37.960><c> you</c><00:01:38.080><c> select</c><00:01:38.470><c> a</c><00:01:38.620><c> cell</c>

00:01:38.820 --> 00:01:38.830 align:start position:0%
and there we go when you select a cell
 

00:01:38.830 --> 00:01:40.500 align:start position:0%
and there we go when you select a cell
with<00:01:38.979><c> number</c><00:01:39.250><c> formatting</c><00:01:39.700><c> you'll</c><00:01:40.150><c> see</c><00:01:40.390><c> the</c>

00:01:40.500 --> 00:01:40.510 align:start position:0%
with number formatting you'll see the
 

00:01:40.510 --> 00:01:42.930 align:start position:0%
with number formatting you'll see the
actual<00:01:41.050><c> value</c><00:01:41.590><c> of</c><00:01:41.620><c> that</c><00:01:41.890><c> cell</c><00:01:42.220><c> in</c><00:01:42.370><c> the</c><00:01:42.490><c> formula</c>

00:01:42.930 --> 00:01:42.940 align:start position:0%
actual value of that cell in the formula
 

00:01:42.940 --> 00:01:45.450 align:start position:0%
actual value of that cell in the formula
bar<00:01:43.150><c> so</c><00:01:44.050><c> the</c><00:01:44.530><c> long</c><00:01:44.740><c> date</c><00:01:44.950><c> number</c><00:01:45.190><c> format</c>

00:01:45.450 --> 00:01:45.460 align:start position:0%
bar so the long date number format
 

00:01:45.460 --> 00:01:47.790 align:start position:0%
bar so the long date number format
hasn't<00:01:46.060><c> changed</c><00:01:46.600><c> the</c><00:01:46.720><c> actual</c><00:01:47.260><c> data</c><00:01:47.500><c> in</c><00:01:47.680><c> our</c>

00:01:47.790 --> 00:01:47.800 align:start position:0%
hasn't changed the actual data in our
 

00:01:47.800 --> 00:01:49.920 align:start position:0%
hasn't changed the actual data in our
cell<00:01:48.100><c> it</c><00:01:48.790><c> only</c><00:01:48.970><c> changes</c><00:01:49.450><c> the</c><00:01:49.630><c> way</c><00:01:49.750><c> it's</c>

00:01:49.920 --> 00:01:49.930 align:start position:0%
cell it only changes the way it's
 

00:01:49.930 --> 00:01:53.400 align:start position:0%
cell it only changes the way it's
displayed<00:01:50.260><c> and</c><00:01:51.150><c> number</c><00:01:52.150><c> formats</c><00:01:52.570><c> don't</c><00:01:53.080><c> just</c>

00:01:53.400 --> 00:01:53.410 align:start position:0%
displayed and number formats don't just
 

00:01:53.410 --> 00:01:56.010 align:start position:0%
displayed and number formats don't just
make<00:01:53.590><c> our</c><00:01:53.740><c> data</c><00:01:53.860><c> easier</c><00:01:54.369><c> to</c><00:01:54.610><c> read</c><00:01:54.850><c> for</c><00:01:55.090><c> example</c>

00:01:56.010 --> 00:01:56.020 align:start position:0%
make our data easier to read for example
 

00:01:56.020 --> 00:01:58.499 align:start position:0%
make our data easier to read for example
since<00:01:56.890><c> Excel</c><00:01:57.220><c> understands</c><00:01:57.970><c> that</c><00:01:58.090><c> this</c><00:01:58.240><c> is</c><00:01:58.300><c> a</c>

00:01:58.499 --> 00:01:58.509 align:start position:0%
since Excel understands that this is a
 

00:01:58.509 --> 00:02:00.660 align:start position:0%
since Excel understands that this is a
calendar<00:01:59.140><c> date</c><00:01:59.350><c> we</c><00:01:59.890><c> can</c><00:02:00.040><c> use</c><00:02:00.220><c> the</c><00:02:00.400><c> fill</c><00:02:00.640><c> handle</c>

00:02:00.660 --> 00:02:00.670 align:start position:0%
calendar date we can use the fill handle
 

00:02:00.670 --> 00:02:03.300 align:start position:0%
calendar date we can use the fill handle
in<00:02:01.330><c> the</c><00:02:01.450><c> lower</c><00:02:01.690><c> right</c><00:02:01.990><c> corner</c><00:02:02.409><c> of</c><00:02:02.440><c> the</c><00:02:02.650><c> cell</c><00:02:02.920><c> to</c>

00:02:03.300 --> 00:02:03.310 align:start position:0%
in the lower right corner of the cell to
 

00:02:03.310 --> 00:02:08.690 align:start position:0%
in the lower right corner of the cell to
continue<00:02:03.850><c> this</c><00:02:04.060><c> series</c><00:02:04.300><c> of</c><00:02:04.570><c> dates</c>

00:02:08.690 --> 00:02:08.700 align:start position:0%
 
 

00:02:08.700 --> 00:02:11.900 align:start position:0%
 
so<00:02:09.660><c> now</c><00:02:09.810><c> we</c><00:02:09.869><c> have</c><00:02:10.140><c> January</c><00:02:10.649><c> 2nd</c><00:02:11.069><c> January</c><00:02:11.340><c> 3rd</c>

00:02:11.900 --> 00:02:11.910 align:start position:0%
so now we have January 2nd January 3rd
 

00:02:11.910 --> 00:02:15.110 align:start position:0%
so now we have January 2nd January 3rd
and<00:02:12.300><c> so</c><00:02:12.569><c> on</c><00:02:13.010><c> definitely</c><00:02:14.010><c> a</c><00:02:14.099><c> lot</c><00:02:14.400><c> easier</c><00:02:14.970><c> than</c>

00:02:15.110 --> 00:02:15.120 align:start position:0%
and so on definitely a lot easier than
 

00:02:15.120 --> 00:02:17.920 align:start position:0%
and so on definitely a lot easier than
entering<00:02:15.450><c> each</c><00:02:15.720><c> of</c><00:02:15.989><c> these</c><00:02:16.080><c> one</c><00:02:16.349><c> by</c><00:02:16.380><c> one</c>

00:02:17.920 --> 00:02:17.930 align:start position:0%
entering each of these one by one
 

00:02:17.930 --> 00:02:20.300 align:start position:0%
entering each of these one by one
unfortunately<00:02:18.930><c> Excel</c><00:02:19.739><c> doesn't</c><00:02:20.069><c> always</c>

00:02:20.300 --> 00:02:20.310 align:start position:0%
unfortunately Excel doesn't always
 

00:02:20.310 --> 00:02:22.610 align:start position:0%
unfortunately Excel doesn't always
understand<00:02:21.180><c> what</c><00:02:21.390><c> we're</c><00:02:21.569><c> trying</c><00:02:21.720><c> to</c><00:02:22.050><c> type</c><00:02:22.290><c> the</c>

00:02:22.610 --> 00:02:22.620 align:start position:0%
understand what we're trying to type the
 

00:02:22.620 --> 00:02:25.460 align:start position:0%
understand what we're trying to type the
same<00:02:22.890><c> way</c><00:02:23.160><c> that</c><00:02:23.370><c> a</c><00:02:23.430><c> person</c><00:02:23.670><c> would</c><00:02:24.090><c> and</c><00:02:24.470><c> because</c>

00:02:25.460 --> 00:02:25.470 align:start position:0%
same way that a person would and because
 

00:02:25.470 --> 00:02:27.860 align:start position:0%
same way that a person would and because
of<00:02:25.500><c> this</c><00:02:25.830><c> Excel</c><00:02:26.550><c> requires</c><00:02:26.910><c> you</c><00:02:27.270><c> to</c><00:02:27.300><c> enter</c><00:02:27.720><c> your</c>

00:02:27.860 --> 00:02:27.870 align:start position:0%
of this Excel requires you to enter your
 

00:02:27.870 --> 00:02:30.860 align:start position:0%
of this Excel requires you to enter your
data<00:02:28.050><c> in</c><00:02:28.380><c> a</c><00:02:28.560><c> pretty</c><00:02:28.860><c> specific</c><00:02:29.100><c> way</c><00:02:29.870><c> for</c>

00:02:30.860 --> 00:02:30.870 align:start position:0%
data in a pretty specific way for
 

00:02:30.870 --> 00:02:32.930 align:start position:0%
data in a pretty specific way for
example<00:02:30.989><c> watch</c><00:02:31.950><c> what</c><00:02:32.130><c> happens</c><00:02:32.459><c> when</c><00:02:32.610><c> we</c><00:02:32.700><c> type</c>

00:02:32.930 --> 00:02:32.940 align:start position:0%
example watch what happens when we type
 

00:02:32.940 --> 00:02:37.190 align:start position:0%
example watch what happens when we type
January<00:02:33.810><c> first</c><00:02:34.319><c> in</c><00:02:34.590><c> this</c><00:02:35.100><c> cell</c><00:02:35.370><c> as</c><00:02:35.870><c> you</c><00:02:36.870><c> can</c>

00:02:37.190 --> 00:02:37.200 align:start position:0%
January first in this cell as you can
 

00:02:37.200 --> 00:02:39.710 align:start position:0%
January first in this cell as you can
see<00:02:37.500><c> the</c><00:02:38.040><c> number</c><00:02:38.400><c> format</c><00:02:38.790><c> has</c><00:02:38.970><c> not</c><00:02:39.150><c> changed</c>

00:02:39.710 --> 00:02:39.720 align:start position:0%
see the number format has not changed
 

00:02:39.720 --> 00:02:41.809 align:start position:0%
see the number format has not changed
this<00:02:40.319><c> cell</c><00:02:40.650><c> is</c><00:02:40.830><c> still</c><00:02:41.130><c> just</c><00:02:41.340><c> using</c><00:02:41.700><c> the</c>

00:02:41.809 --> 00:02:41.819 align:start position:0%
this cell is still just using the
 

00:02:41.819 --> 00:02:43.790 align:start position:0%
this cell is still just using the
general<00:02:42.209><c> number</c><00:02:42.360><c> format</c><00:02:42.540><c> and</c><00:02:43.470><c> that</c><00:02:43.560><c> means</c>

00:02:43.790 --> 00:02:43.800 align:start position:0%
general number format and that means
 

00:02:43.800 --> 00:02:45.979 align:start position:0%
general number format and that means
Excel<00:02:44.220><c> didn't</c><00:02:44.610><c> understand</c><00:02:45.150><c> what</c><00:02:45.300><c> we</c><00:02:45.450><c> wanted</c>

00:02:45.979 --> 00:02:45.989 align:start position:0%
Excel didn't understand what we wanted
 

00:02:45.989 --> 00:02:48.050 align:start position:0%
Excel didn't understand what we wanted
it<00:02:46.110><c> also</c><00:02:46.680><c> means</c><00:02:46.980><c> our</c><00:02:47.160><c> fill</c><00:02:47.489><c> handle</c><00:02:47.880><c> isn't</c>

00:02:48.050 --> 00:02:48.060 align:start position:0%
it also means our fill handle isn't
 

00:02:48.060 --> 00:02:50.690 align:start position:0%
it also means our fill handle isn't
going<00:02:48.330><c> to</c><00:02:48.390><c> work</c><00:02:48.510><c> correctly</c><00:02:49.370><c> instead</c><00:02:50.370><c> it</c><00:02:50.670><c> just</c>

00:02:50.690 --> 00:02:50.700 align:start position:0%
going to work correctly instead it just
 

00:02:50.700 --> 00:02:52.670 align:start position:0%
going to work correctly instead it just
copies<00:02:51.330><c> the</c><00:02:51.360><c> data</c><00:02:51.630><c> from</c><00:02:51.930><c> this</c><00:02:52.080><c> first</c><00:02:52.350><c> cell</c>

00:02:52.670 --> 00:02:52.680 align:start position:0%
copies the data from this first cell
 

00:02:52.680 --> 00:02:55.550 align:start position:0%
copies the data from this first cell
which<00:02:53.010><c> isn't</c><00:02:53.670><c> what</c><00:02:53.760><c> we</c><00:02:53.910><c> want</c><00:02:54.150><c> to</c><00:02:55.019><c> fix</c><00:02:55.260><c> this</c>

00:02:55.550 --> 00:02:55.560 align:start position:0%
which isn't what we want to fix this
 

00:02:55.560 --> 00:02:57.380 align:start position:0%
which isn't what we want to fix this
will<00:02:56.130><c> need</c><00:02:56.280><c> to</c><00:02:56.400><c> change</c><00:02:56.760><c> this</c><00:02:56.970><c> value</c><00:02:57.030><c> to</c>

00:02:57.380 --> 00:02:57.390 align:start position:0%
will need to change this value to
 

00:02:57.390 --> 00:03:00.289 align:start position:0%
will need to change this value to
something<00:02:57.660><c> Excel</c><00:02:58.110><c> can</c><00:02:58.470><c> understand</c><00:02:59.160><c> such</c><00:02:59.819><c> as</c><00:02:59.970><c> 1</c>

00:03:00.289 --> 00:03:00.299 align:start position:0%
something Excel can understand such as 1
 

00:03:00.299 --> 00:03:05.150 align:start position:0%
something Excel can understand such as 1
+<00:03:00.660><c> 1</c><00:03:00.690><c> /</c><00:03:01.319><c> 2015</c><00:03:02.130><c> or</c><00:03:02.430><c> just</c><00:03:02.930><c> January</c><00:03:03.930><c> 1</c><00:03:04.290><c> without</c><00:03:04.830><c> the</c>

00:03:05.150 --> 00:03:05.160 align:start position:0%
+ 1 / 2015 or just January 1 without the
 

00:03:05.160 --> 00:03:08.360 align:start position:0%
+ 1 / 2015 or just January 1 without the
St

00:03:08.360 --> 00:03:08.370 align:start position:0%
 
 

00:03:08.370 --> 00:03:11.030 align:start position:0%
 
there<00:03:08.970><c> we</c><00:03:09.300><c> go</c><00:03:09.720><c> so</c><00:03:10.140><c> you</c><00:03:10.230><c> can</c><00:03:10.410><c> see</c><00:03:10.709><c> that</c><00:03:10.890><c> Excel</c>

00:03:11.030 --> 00:03:11.040 align:start position:0%
there we go so you can see that Excel
 

00:03:11.040 --> 00:03:14.030 align:start position:0%
there we go so you can see that Excel
has<00:03:11.280><c> applied</c><00:03:11.940><c> a</c><00:03:12.330><c> custom</c><00:03:13.050><c> date</c><00:03:13.230><c> format</c><00:03:13.739><c> to</c><00:03:13.890><c> this</c>

00:03:14.030 --> 00:03:14.040 align:start position:0%
has applied a custom date format to this
 

00:03:14.040 --> 00:03:16.430 align:start position:0%
has applied a custom date format to this
cell<00:03:14.310><c> and</c><00:03:14.580><c> that's</c><00:03:15.150><c> because</c><00:03:15.480><c> it</c><00:03:15.629><c> understood</c>

00:03:16.430 --> 00:03:16.440 align:start position:0%
cell and that's because it understood
 

00:03:16.440 --> 00:03:18.800 align:start position:0%
cell and that's because it understood
what<00:03:16.709><c> we</c><00:03:16.830><c> wanted</c><00:03:17.250><c> and</c><00:03:17.970><c> now</c><00:03:18.239><c> just</c><00:03:18.599><c> like</c><00:03:18.780><c> before</c>

00:03:18.800 --> 00:03:18.810 align:start position:0%
what we wanted and now just like before
 

00:03:18.810 --> 00:03:21.559 align:start position:0%
what we wanted and now just like before
we<00:03:19.440><c> can</c><00:03:19.590><c> see</c><00:03:19.769><c> the</c><00:03:19.920><c> cells</c><00:03:20.160><c> actual</c><00:03:20.879><c> value</c><00:03:21.300><c> in</c><00:03:21.450><c> the</c>

00:03:21.559 --> 00:03:21.569 align:start position:0%
we can see the cells actual value in the
 

00:03:21.569 --> 00:03:24.229 align:start position:0%
we can see the cells actual value in the
formula<00:03:22.050><c> bar</c><00:03:22.080><c> and</c><00:03:22.530><c> we</c><00:03:23.250><c> can</c><00:03:23.370><c> even</c><00:03:23.550><c> use</c><00:03:23.700><c> the</c><00:03:23.879><c> fill</c>

00:03:24.229 --> 00:03:24.239 align:start position:0%
formula bar and we can even use the fill
 

00:03:24.239 --> 00:03:27.780 align:start position:0%
formula bar and we can even use the fill
handle<00:03:24.450><c> to</c><00:03:24.690><c> continue</c><00:03:25.349><c> this</c><00:03:25.500><c> series</c><00:03:25.860><c> of</c><00:03:25.980><c> dates</c>

00:03:27.780 --> 00:03:27.790 align:start position:0%
handle to continue this series of dates
 

00:03:27.790 --> 00:03:30.440 align:start position:0%
handle to continue this series of dates
let's<00:03:28.720><c> take</c><00:03:28.930><c> a</c><00:03:28.959><c> look</c><00:03:29.170><c> at</c><00:03:29.319><c> another</c><00:03:29.409><c> useful</c><00:03:30.129><c> but</c>

00:03:30.440 --> 00:03:30.450 align:start position:0%
let's take a look at another useful but
 

00:03:30.450 --> 00:03:32.660 align:start position:0%
let's take a look at another useful but
potentially<00:03:31.450><c> confusing</c><00:03:31.810><c> number</c><00:03:32.260><c> format</c>

00:03:32.660 --> 00:03:32.670 align:start position:0%
potentially confusing number format
 

00:03:32.670 --> 00:03:35.729 align:start position:0%
potentially confusing number format
percentages<00:03:33.930><c> remember</c><00:03:34.930><c> how</c><00:03:35.049><c> we</c><00:03:35.110><c> said</c><00:03:35.349><c> before</c>

00:03:35.729 --> 00:03:35.739 align:start position:0%
percentages remember how we said before
 

00:03:35.739 --> 00:03:37.589 align:start position:0%
percentages remember how we said before
that<00:03:35.769><c> certain</c><00:03:36.459><c> data</c><00:03:36.640><c> needs</c><00:03:36.939><c> to</c><00:03:37.030><c> be</c><00:03:37.090><c> entered</c><00:03:37.450><c> in</c>

00:03:37.589 --> 00:03:37.599 align:start position:0%
that certain data needs to be entered in
 

00:03:37.599 --> 00:03:40.350 align:start position:0%
that certain data needs to be entered in
a<00:03:37.689><c> certain</c><00:03:38.110><c> way</c><00:03:38.319><c> well</c><00:03:39.280><c> when</c><00:03:39.879><c> you</c><00:03:40.000><c> type</c><00:03:40.209><c> a</c>

00:03:40.350 --> 00:03:40.360 align:start position:0%
a certain way well when you type a
 

00:03:40.360 --> 00:03:42.360 align:start position:0%
a certain way well when you type a
number<00:03:40.569><c> followed</c><00:03:41.200><c> by</c><00:03:41.230><c> the</c><00:03:41.349><c> percent</c><00:03:41.860><c> sign</c><00:03:42.069><c> and</c>

00:03:42.360 --> 00:03:42.370 align:start position:0%
number followed by the percent sign and
 

00:03:42.370 --> 00:03:43.259 align:start position:0%
number followed by the percent sign and
press<00:03:42.579><c> Enter</c>

00:03:43.259 --> 00:03:43.269 align:start position:0%
press Enter
 

00:03:43.269 --> 00:03:45.330 align:start position:0%
press Enter
the<00:03:43.629><c> percentage</c><00:03:44.140><c> number</c><00:03:44.560><c> format</c><00:03:44.590><c> will</c><00:03:45.190><c> be</c>

00:03:45.330 --> 00:03:45.340 align:start position:0%
the percentage number format will be
 

00:03:45.340 --> 00:03:47.369 align:start position:0%
the percentage number format will be
applied<00:03:45.700><c> automatically</c><00:03:46.510><c> to</c><00:03:46.750><c> that</c><00:03:46.900><c> cell</c><00:03:47.170><c> in</c>

00:03:47.369 --> 00:03:47.379 align:start position:0%
applied automatically to that cell in
 

00:03:47.379 --> 00:03:49.470 align:start position:0%
applied automatically to that cell in
this<00:03:48.190><c> example</c><00:03:48.610><c> let's</c><00:03:49.000><c> say</c><00:03:49.180><c> that</c><00:03:49.299><c> we're</c>

00:03:49.470 --> 00:03:49.480 align:start position:0%
this example let's say that we're
 

00:03:49.480 --> 00:03:53.130 align:start position:0%
this example let's say that we're
working<00:03:49.659><c> with</c><00:03:50.049><c> an</c><00:03:50.230><c> 8%</c><00:03:50.799><c> sales</c><00:03:51.220><c> tax</c><00:03:51.579><c> rate</c><00:03:51.840><c> now</c><00:03:52.840><c> as</c>

00:03:53.130 --> 00:03:53.140 align:start position:0%
working with an 8% sales tax rate now as
 

00:03:53.140 --> 00:03:55.009 align:start position:0%
working with an 8% sales tax rate now as
you<00:03:53.650><c> may</c><00:03:53.859><c> remember</c><00:03:54.159><c> from</c><00:03:54.310><c> math</c><00:03:54.640><c> class</c>

00:03:55.009 --> 00:03:55.019 align:start position:0%
you may remember from math class
 

00:03:55.019 --> 00:03:57.210 align:start position:0%
you may remember from math class
percentages<00:03:56.019><c> can</c><00:03:56.230><c> also</c><00:03:56.470><c> be</c><00:03:56.769><c> written</c><00:03:56.950><c> as</c><00:03:57.159><c> a</c>

00:03:57.210 --> 00:03:57.220 align:start position:0%
percentages can also be written as a
 

00:03:57.220 --> 00:04:00.300 align:start position:0%
percentages can also be written as a
decimal<00:03:57.489><c> number</c><00:03:58.019><c> for</c><00:03:59.019><c> example</c><00:03:59.109><c> if</c><00:03:59.709><c> I</c><00:03:59.980><c> change</c>

00:04:00.300 --> 00:04:00.310 align:start position:0%
decimal number for example if I change
 

00:04:00.310 --> 00:04:02.550 align:start position:0%
decimal number for example if I change
the<00:04:00.579><c> number</c><00:04:00.730><c> format</c><00:04:00.909><c> for</c><00:04:01.480><c> this</c><00:04:01.629><c> cell</c><00:04:01.930><c> back</c><00:04:02.319><c> to</c>

00:04:02.550 --> 00:04:02.560 align:start position:0%
the number format for this cell back to
 

00:04:02.560 --> 00:04:06.780 align:start position:0%
the number format for this cell back to
general<00:04:03.150><c> it'll</c><00:04:04.150><c> appear</c><00:04:04.510><c> as</c><00:04:05.010><c> 0.08</c><00:04:06.010><c> which</c><00:04:06.519><c> is</c>

00:04:06.780 --> 00:04:06.790 align:start position:0%
general it'll appear as 0.08 which is
 

00:04:06.790 --> 00:04:10.080 align:start position:0%
general it'll appear as 0.08 which is
just<00:04:07.239><c> another</c><00:04:07.510><c> way</c><00:04:07.750><c> of</c><00:04:07.780><c> writing</c><00:04:07.950><c> 8%</c><00:04:08.950><c> I</c><00:04:09.190><c> point</c>

00:04:10.080 --> 00:04:10.090 align:start position:0%
just another way of writing 8% I point
 

00:04:10.090 --> 00:04:11.910 align:start position:0%
just another way of writing 8% I point
this<00:04:10.209><c> out</c><00:04:10.420><c> mainly</c><00:04:10.900><c> because</c><00:04:11.260><c> it's</c><00:04:11.590><c> easy</c><00:04:11.829><c> to</c>

00:04:11.910 --> 00:04:11.920 align:start position:0%
this out mainly because it's easy to
 

00:04:11.920 --> 00:04:13.500 align:start position:0%
this out mainly because it's easy to
make<00:04:12.010><c> a</c><00:04:12.280><c> mistake</c><00:04:12.549><c> with</c><00:04:13.000><c> percentage</c>

00:04:13.500 --> 00:04:13.510 align:start position:0%
make a mistake with percentage
 

00:04:13.510 --> 00:04:15.149 align:start position:0%
make a mistake with percentage
formatting<00:04:14.049><c> if</c><00:04:14.200><c> you're</c><00:04:14.440><c> not</c><00:04:14.620><c> being</c><00:04:14.950><c> careful</c>

00:04:15.149 --> 00:04:15.159 align:start position:0%
formatting if you're not being careful
 

00:04:15.159 --> 00:04:18.840 align:start position:0%
formatting if you're not being careful
for<00:04:16.060><c> example</c><00:04:16.600><c> if</c><00:04:16.780><c> we</c><00:04:17.169><c> tie</c><00:04:17.380><c> it</c><00:04:17.440><c> 8</c><00:04:17.680><c> into</c><00:04:18.220><c> an</c><00:04:18.340><c> empty</c>

00:04:18.840 --> 00:04:18.850 align:start position:0%
for example if we tie it 8 into an empty
 

00:04:18.850 --> 00:04:21.060 align:start position:0%
for example if we tie it 8 into an empty
cell<00:04:19.090><c> and</c><00:04:19.359><c> then</c><00:04:20.229><c> apply</c><00:04:20.530><c> percentage</c>

00:04:21.060 --> 00:04:21.070 align:start position:0%
cell and then apply percentage
 

00:04:21.070 --> 00:04:23.969 align:start position:0%
cell and then apply percentage
formatting<00:04:21.579><c> afterward</c><00:04:22.620><c> Excel</c><00:04:23.620><c> will</c><00:04:23.770><c> think</c>

00:04:23.969 --> 00:04:23.979 align:start position:0%
formatting afterward Excel will think
 

00:04:23.979 --> 00:04:26.700 align:start position:0%
formatting afterward Excel will think
that<00:04:24.039><c> we</c><00:04:24.250><c> met</c><00:04:24.460><c> 800</c><00:04:25.300><c> percent</c><00:04:25.479><c> which</c><00:04:25.990><c> isn't</c><00:04:26.530><c> even</c>

00:04:26.700 --> 00:04:26.710 align:start position:0%
that we met 800 percent which isn't even
 

00:04:26.710 --> 00:04:29.040 align:start position:0%
that we met 800 percent which isn't even
close<00:04:27.039><c> to</c><00:04:27.490><c> what</c><00:04:27.639><c> we</c><00:04:27.789><c> wanted</c><00:04:28.090><c> in</c><00:04:28.300><c> our</c>

00:04:29.040 --> 00:04:29.050 align:start position:0%
close to what we wanted in our
 

00:04:29.050 --> 00:04:31.620 align:start position:0%
close to what we wanted in our
experience<00:04:29.650><c> it's</c><00:04:30.130><c> best</c><00:04:30.580><c> just</c><00:04:30.760><c> to</c><00:04:31.030><c> include</c><00:04:31.479><c> the</c>

00:04:31.620 --> 00:04:31.630 align:start position:0%
experience it's best just to include the
 

00:04:31.630 --> 00:04:33.570 align:start position:0%
experience it's best just to include the
percent<00:04:31.990><c> sign</c><00:04:32.199><c> whenever</c><00:04:32.919><c> you're</c><00:04:33.099><c> entering</c><00:04:33.130><c> a</c>

00:04:33.570 --> 00:04:33.580 align:start position:0%
percent sign whenever you're entering a
 

00:04:33.580 --> 00:04:35.879 align:start position:0%
percent sign whenever you're entering a
percentage<00:04:34.120><c> into</c><00:04:34.479><c> Excel</c><00:04:34.870><c> that</c><00:04:35.500><c> way</c><00:04:35.680><c> there's</c>

00:04:35.879 --> 00:04:35.889 align:start position:0%
percentage into Excel that way there's
 

00:04:35.889 --> 00:04:38.310 align:start position:0%
percentage into Excel that way there's
much<00:04:36.340><c> less</c><00:04:36.639><c> risk</c><00:04:36.970><c> of</c><00:04:37.210><c> making</c><00:04:37.690><c> a</c><00:04:37.750><c> mistake</c><00:04:37.900><c> like</c>

00:04:38.310 --> 00:04:38.320 align:start position:0%
much less risk of making a mistake like
 

00:04:38.320 --> 00:04:41.370 align:start position:0%
much less risk of making a mistake like
this<00:04:39.030><c> okay</c><00:04:40.030><c> there's</c><00:04:40.300><c> just</c><00:04:40.389><c> one</c><00:04:40.900><c> last</c><00:04:41.080><c> thing</c>

00:04:41.370 --> 00:04:41.380 align:start position:0%
this okay there's just one last thing
 

00:04:41.380 --> 00:04:43.529 align:start position:0%
this okay there's just one last thing
we'd<00:04:41.530><c> like</c><00:04:41.560><c> to</c><00:04:41.740><c> point</c><00:04:41.979><c> out</c><00:04:42.220><c> below</c><00:04:43.210><c> the</c><00:04:43.389><c> number</c>

00:04:43.529 --> 00:04:43.539 align:start position:0%
we'd like to point out below the number
 

00:04:43.539 --> 00:04:45.870 align:start position:0%
we'd like to point out below the number
format<00:04:44.050><c> drop-down</c><00:04:44.349><c> menu</c><00:04:44.919><c> you'll</c><00:04:45.520><c> see</c><00:04:45.610><c> these</c>

00:04:45.870 --> 00:04:45.880 align:start position:0%
format drop-down menu you'll see these
 

00:04:45.880 --> 00:04:47.790 align:start position:0%
format drop-down menu you'll see these
small<00:04:46.300><c> buttons</c><00:04:46.720><c> with</c><00:04:47.110><c> a</c><00:04:47.139><c> left</c><00:04:47.500><c> and</c><00:04:47.710><c> right</c>

00:04:47.790 --> 00:04:47.800 align:start position:0%
small buttons with a left and right
 

00:04:47.800 --> 00:04:50.580 align:start position:0%
small buttons with a left and right
arrow<00:04:48.449><c> these</c><00:04:49.449><c> commands</c><00:04:49.990><c> allow</c><00:04:50.380><c> you</c><00:04:50.440><c> to</c>

00:04:50.580 --> 00:04:50.590 align:start position:0%
arrow these commands allow you to
 

00:04:50.590 --> 00:04:52.770 align:start position:0%
arrow these commands allow you to
control<00:04:51.010><c> how</c><00:04:51.310><c> many</c><00:04:51.370><c> decimal</c><00:04:52.090><c> places</c><00:04:52.240><c> are</c>

00:04:52.770 --> 00:04:52.780 align:start position:0%
control how many decimal places are
 

00:04:52.780 --> 00:04:56.159 align:start position:0%
control how many decimal places are
displayed<00:04:53.289><c> in</c><00:04:53.590><c> your</c><00:04:53.710><c> cell</c><00:04:53.979><c> as</c><00:04:54.690><c> an</c><00:04:55.690><c> example</c>

00:04:56.159 --> 00:04:56.169 align:start position:0%
displayed in your cell as an example
 

00:04:56.169 --> 00:04:57.930 align:start position:0%
displayed in your cell as an example
let's<00:04:56.590><c> say</c><00:04:56.830><c> I'm</c><00:04:56.919><c> working</c><00:04:57.220><c> with</c><00:04:57.370><c> a</c><00:04:57.400><c> currency</c>

00:04:57.930 --> 00:04:57.940 align:start position:0%
let's say I'm working with a currency
 

00:04:57.940 --> 00:05:02.580 align:start position:0%
let's say I'm working with a currency
value<00:04:58.389><c> like</c><00:04:59.970><c> $19.95</c><00:05:01.050><c> now</c><00:05:02.050><c> as</c><00:05:02.229><c> you</c><00:05:02.410><c> can</c><00:05:02.530><c> see</c>

00:05:02.580 --> 00:05:02.590 align:start position:0%
value like $19.95 now as you can see
 

00:05:02.590 --> 00:05:05.250 align:start position:0%
value like $19.95 now as you can see
Excel<00:05:03.430><c> automatically</c><00:05:04.240><c> applied</c><00:05:04.599><c> currency</c>

00:05:05.250 --> 00:05:05.260 align:start position:0%
Excel automatically applied currency
 

00:05:05.260 --> 00:05:07.020 align:start position:0%
Excel automatically applied currency
formatting<00:05:05.680><c> when</c><00:05:06.070><c> we</c><00:05:06.250><c> included</c><00:05:06.699><c> the</c><00:05:06.789><c> dollar</c>

00:05:07.020 --> 00:05:07.030 align:start position:0%
formatting when we included the dollar
 

00:05:07.030 --> 00:05:09.900 align:start position:0%
formatting when we included the dollar
sign<00:05:07.330><c> in</c><00:05:07.510><c> this</c><00:05:07.630><c> cell</c><00:05:08.160><c> now</c><00:05:09.160><c> you</c><00:05:09.220><c> can</c><00:05:09.430><c> show</c><00:05:09.639><c> more</c>

00:05:09.900 --> 00:05:09.910 align:start position:0%
sign in this cell now you can show more
 

00:05:09.910 --> 00:05:12.839 align:start position:0%
sign in this cell now you can show more
decimal<00:05:10.419><c> places</c><00:05:10.690><c> to</c><00:05:10.900><c> increase</c><00:05:11.710><c> precision</c><00:05:12.130><c> or</c>

00:05:12.839 --> 00:05:12.849 align:start position:0%
decimal places to increase precision or
 

00:05:12.849 --> 00:05:15.899 align:start position:0%
decimal places to increase precision or
show<00:05:13.210><c> fewer</c><00:05:13.659><c> to</c><00:05:14.020><c> simplify</c><00:05:14.830><c> your</c><00:05:15.010><c> data</c><00:05:15.220><c> or</c><00:05:15.580><c> even</c>

00:05:15.899 --> 00:05:15.909 align:start position:0%
show fewer to simplify your data or even
 

00:05:15.909 --> 00:05:18.110 align:start position:0%
show fewer to simplify your data or even
round<00:05:16.539><c> it</c><00:05:16.810><c> to</c><00:05:16.840><c> the</c><00:05:16.960><c> nearest</c><00:05:17.080><c> whole</c><00:05:17.620><c> number</c>

00:05:18.110 --> 00:05:18.120 align:start position:0%
round it to the nearest whole number
 

00:05:18.120 --> 00:05:20.909 align:start position:0%
round it to the nearest whole number
just<00:05:19.120><c> like</c><00:05:19.270><c> before</c><00:05:19.690><c> we're</c><00:05:20.289><c> not</c><00:05:20.380><c> changing</c><00:05:20.710><c> the</c>

00:05:20.909 --> 00:05:20.919 align:start position:0%
just like before we're not changing the
 

00:05:20.919 --> 00:05:23.850 align:start position:0%
just like before we're not changing the
actual<00:05:21.460><c> value</c><00:05:21.970><c> of</c><00:05:22.000><c> this</c><00:05:22.330><c> cell</c><00:05:22.599><c> as</c><00:05:22.870><c> we</c><00:05:23.380><c> can</c><00:05:23.560><c> see</c>

00:05:23.850 --> 00:05:23.860 align:start position:0%
actual value of this cell as we can see
 

00:05:23.860 --> 00:05:26.070 align:start position:0%
actual value of this cell as we can see
in<00:05:24.010><c> the</c><00:05:24.159><c> formula</c><00:05:24.639><c> bar</c><00:05:24.820><c> we're</c><00:05:25.330><c> just</c><00:05:25.599><c> making</c><00:05:25.960><c> it</c>

00:05:26.070 --> 00:05:26.080 align:start position:0%
in the formula bar we're just making it
 

00:05:26.080 --> 00:05:29.700 align:start position:0%
in the formula bar we're just making it
easier<00:05:26.530><c> to</c><00:05:26.710><c> read</c><00:05:27.010><c> in</c><00:05:27.310><c> our</c><00:05:27.580><c> spreadsheet</c><00:05:28.710><c> now</c>

00:05:29.700 --> 00:05:29.710 align:start position:0%
easier to read in our spreadsheet now
 

00:05:29.710 --> 00:05:31.409 align:start position:0%
easier to read in our spreadsheet now
that<00:05:29.949><c> you</c><00:05:30.039><c> know</c><00:05:30.220><c> how</c><00:05:30.400><c> number</c><00:05:30.729><c> formats</c><00:05:31.090><c> work</c>

00:05:31.409 --> 00:05:31.419 align:start position:0%
that you know how number formats work
 

00:05:31.419 --> 00:05:33.810 align:start position:0%
that you know how number formats work
take<00:05:32.110><c> some</c><00:05:32.320><c> time</c><00:05:32.560><c> to</c><00:05:32.830><c> ensure</c><00:05:33.010><c> that</c><00:05:33.280><c> you're</c>

00:05:33.810 --> 00:05:33.820 align:start position:0%
take some time to ensure that you're
 

00:05:33.820 --> 00:05:37.450 align:start position:0%
take some time to ensure that you're
using<00:05:34.060><c> them</c><00:05:34.360><c> correctly</c><00:05:34.599><c> in</c><00:05:35.199><c> your</c><00:05:35.620><c> spreadsheet</c>

00:05:37.450 --> 00:05:37.460 align:start position:0%
using them correctly in your spreadsheet
 

00:05:37.460 --> 00:05:39.520 align:start position:0%
using them correctly in your spreadsheet
you