High now that we know that every validating Excel is stored as a number and it can be verified by the
formula is number let's proceed to see how a date can be present day to the end user when he wishes
to take a printout or wishes to see a date in a certain form.
The skin of the deed.
Yes.
How I can change the skin a date.
Well you would have already come across such a phenomenon where you would have right click on a date
went inside.
Format says something that can also be activated using the shot could you control one.
Once you are inside for an hour says you would have picked up the desired presentation value for that.
For example in this case if I pick this value it would show that day in January.
Then what did you do.
Followed by a coma and then the year.
Now this is just the skin the day if I double click on any.
In this case it happens to be a formula but let's see the previous one.
If I double click on any notice internally it is showing you the D in m b y format.
Now where is it coming from.
What is the origin of this format and the why.
Well if you could quickly go to Control Panel settings of your Microsoft PC which I will do in my case
I'll press or not because they're already on my screen now.
Within that you'll notice there's something called Legion and language in the older version of operating
system of Windows.
You would have phone a consolidated word collegian and language in some of the occasions you might also
get the entire category group where you would find this block language and region.
So what I do is I choose the category I see large icons and then I specifically go to region within
region.
What I get to see is why number one you can change the format from English United States to English
let's say English UK English India.
And based on that country's convention of showing the dates it weaken or to the Y or d m y.
For example in this case I go one step ahead.
I go to the traditional settings and then I go to the Dabb of bait and I'm going to choose that as the
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.
OK.
Get out of the setting.
When I are back to excel.
Notice this time when I write 22 slash 0 8 slash two thousand nine.
Now typically this is what the format as I press enter it accepts that as I did how do I know for sure
if I right is number formula and check for the accuracy and validity of the data.
It will say two however how dated in the same day in the MDI form at this time 22 slash 2009 it would
not accept that as it did.
So basically the format initial format being y or M.D Y is controlled by the control panel settings
by default which is don't do m b y.
So I go back through Control Panel settings.
Region Yes.
Within which I go additional settings I go to that date tab and change that to MTV format which is the
default format.
Same for long boot or as I may simply go to the button thing reset Yes.
So it's coming back to the original form default setting.
Read.
OK apply.
OK.
And a closing button of control panel and go back to make sushi.
Notice that did that were entered earlier doesn't de-stabilize it still is 22 August.
Although internally when I double click it shows me it 22 2009.
What about this one by DoubleClick click and then press enter it then gets converted to the correct
beat.
So all in all the M.D why or the invite can be changed to Control Panel settings for Marcellinus just
the skin and every validator is a number which can be verified using is numbered and all these concepts
will be applied.
When we go to the next couple of exercises.