1

00:00:00,560 --> 00:00:08,040

High now that we know that every validating Excel is stored as a number and it can be verified by the



2

00:00:08,050 --> 00:00:14,490

formula is number let's proceed to see how a date can be present day to the end user when he wishes



3

00:00:14,490 --> 00:00:18,620

to take a printout or wishes to see a date in a certain form.



4

00:00:18,750 --> 00:00:19,820

The skin of the deed.



5

00:00:19,950 --> 00:00:20,740

Yes.



6

00:00:20,760 --> 00:00:23,150

How I can change the skin a date.



7

00:00:23,220 --> 00:00:27,750

Well you would have already come across such a phenomenon where you would have right click on a date



8

00:00:28,140 --> 00:00:28,910

went inside.



9

00:00:28,910 --> 00:00:33,800

Format says something that can also be activated using the shot could you control one.



10

00:00:33,960 --> 00:00:39,620

Once you are inside for an hour says you would have picked up the desired presentation value for that.



11

00:00:39,660 --> 00:00:44,640

For example in this case if I pick this value it would show that day in January.



12

00:00:44,640 --> 00:00:45,760

Then what did you do.



13

00:00:45,780 --> 00:00:48,110

Followed by a coma and then the year.



14

00:00:48,120 --> 00:00:51,650

Now this is just the skin the day if I double click on any.



15

00:00:51,810 --> 00:00:55,170

In this case it happens to be a formula but let's see the previous one.



16

00:00:55,230 --> 00:01:01,340

If I double click on any notice internally it is showing you the D in m b y format.



17

00:01:01,500 --> 00:01:03,330

Now where is it coming from.



18

00:01:03,330 --> 00:01:05,970

What is the origin of this format and the why.



19

00:01:06,150 --> 00:01:11,310

Well if you could quickly go to Control Panel settings of your Microsoft PC which I will do in my case



20

00:01:11,340 --> 00:01:14,630

I'll press or not because they're already on my screen now.



21

00:01:14,730 --> 00:01:19,920

Within that you'll notice there's something called Legion and language in the older version of operating



22

00:01:19,920 --> 00:01:21,210

system of Windows.



23

00:01:21,370 --> 00:01:27,090

You would have phone a consolidated word collegian and language in some of the occasions you might also



24

00:01:27,090 --> 00:01:33,240

get the entire category group where you would find this block language and region.



25

00:01:33,390 --> 00:01:41,250

So what I do is I choose the category I see large icons and then I specifically go to region within



26

00:01:41,250 --> 00:01:41,850

region.



27

00:01:42,000 --> 00:01:47,910

What I get to see is why number one you can change the format from English United States to English



28

00:01:47,910 --> 00:01:50,510

let's say English UK English India.



29

00:01:50,670 --> 00:01:57,090

And based on that country's convention of showing the dates it weaken or to the Y or d m y.



30

00:01:57,270 --> 00:02:00,370

For example in this case I go one step ahead.



31

00:02:00,390 --> 00:02:07,590

I go to the traditional settings and then I go to the Dabb of bait and I'm going to choose that as the



32

00:02:07,680 --> 00:02:19,200

m y d m y and let that b b m y in this case do the M Y and I'm going to press apply button ok and apply.



33

00:02:19,230 --> 00:02:19,680

OK.



34

00:02:19,680 --> 00:02:20,870

Get out of the setting.



35

00:02:21,000 --> 00:02:22,600

When I are back to excel.



36

00:02:22,750 --> 00:02:29,060

Notice this time when I write 22 slash 0 8 slash two thousand nine.



37

00:02:29,070 --> 00:02:36,570

Now typically this is what the format as I press enter it accepts that as I did how do I know for sure



38

00:02:36,780 --> 00:02:41,950

if I right is number formula and check for the accuracy and validity of the data.



39

00:02:42,000 --> 00:02:50,820

It will say two however how dated in the same day in the MDI form at this time 22 slash 2009 it would



40

00:02:50,820 --> 00:02:52,530

not accept that as it did.



41

00:02:52,770 --> 00:02:59,670

So basically the format initial format being y or M.D Y is controlled by the control panel settings



42

00:03:00,000 --> 00:03:03,750

by default which is don't do m b y.



43

00:03:04,110 --> 00:03:06,790

So I go back through Control Panel settings.



44

00:03:06,920 --> 00:03:08,630

Region Yes.



45

00:03:08,670 --> 00:03:15,570

Within which I go additional settings I go to that date tab and change that to MTV format which is the



46

00:03:15,570 --> 00:03:16,530

default format.



47

00:03:16,620 --> 00:03:23,290

Same for long boot or as I may simply go to the button thing reset Yes.



48

00:03:23,370 --> 00:03:26,460

So it's coming back to the original form default setting.



49

00:03:26,490 --> 00:03:26,780

Read.



50

00:03:26,810 --> 00:03:28,120

OK apply.



51

00:03:28,240 --> 00:03:29,040

OK.



52

00:03:29,250 --> 00:03:33,490

And a closing button of control panel and go back to make sushi.



53

00:03:33,640 --> 00:03:39,410

Notice that did that were entered earlier doesn't de-stabilize it still is 22 August.



54

00:03:39,450 --> 00:03:43,260

Although internally when I double click it shows me it 22 2009.



55

00:03:43,360 --> 00:03:47,740

What about this one by DoubleClick click and then press enter it then gets converted to the correct



56

00:03:47,790 --> 00:03:48,640

beat.



57

00:03:49,330 --> 00:03:55,180

So all in all the M.D why or the invite can be changed to Control Panel settings for Marcellinus just



58

00:03:55,180 --> 00:04:01,520

the skin and every validator is a number which can be verified using is numbered and all these concepts



59

00:04:01,520 --> 00:04:02,250

will be applied.



60

00:04:02,260 --> 00:04:04,480

When we go to the next couple of exercises.