6 hours 3 minutes
okay, in this lesson, I'm going to try to explain to you what data types exist in excel
and how you can create or use custom data types and create more.
So let's not beat around the bush and switch directly to excel.
And we have a simple table here, and some of these ah numbers cells have been already performative. And I want you to see
what it means to use different data types of formats. So let's look at first this still here we have some calculation off fuels
used spent Sorry, purchased and and how much money did you spend?
so here we have
number amount of fuel in leaders purchased for somebody in his car. And you see, here we have 29 point into a tree.
Now, when we right click on this cell
and go down and present form, it sells
the first tab in this newly opened window or box is
what kind of number do we have in this cell so it can be general,
and in this case, it will just display what you have typed. So they have no specific number for Mitt.
But because this is the amount of fuel. So it's, um, number. We wanted to be a number, so we can use 1000 separator.
Of course, if it's ah if its purchase of AH fuel for car, it makes no sense to put 1000 separator because you're probably you don't have a car in which you can buy more than
1000 liters arm or in your tank, so it's not going to happen. But let's leave it like this and the You have different types off
off choices for negative numbers. So if you can have it, for example, for accounting purposes, if it's a negative number, you're not going to purchase a negative number off leaders for your car off fuel. But if it's some kind of accounting table,
it's sometimes it's usual to not put minus in front of number, but make it
appear red or you can put it in in brackets or parenthesis is, or you could put it in
parentheses and also make it red. So there are
and you can choose how the negative numbers will be displayed.
the most important thing is how many decimal places you want. So if it's some kind of financial calculation. It is normal to have two decimal places
now. In some countries, for example, you don't use two decimal places. In most of calculations, you go with zero,
and then them Excel is using standard rounding conventions. So if it's a below 0.5, then it's going to be rounded to lower number. If it's Ah, Bob. So, for example, is 53 is going to be around 2 30 but only but is displayed. So this is important.
The number in the cell remains the same, so
let's make it back to
We see here 29
and let's reformat the cell to show exactly two decimal places. So this is about the number.
So then we have a price. And imagine that you're in Europe like I am
If you're not. Of course, if you're in Europe, you don't have to imagine. And then the price is 31 euro
for the 29.23 liters off fuel, which is possible in some countries,
and, uh, then you then you former to this cell,
and this health has has been preform. It'd for a currency. So it's um,
it's, Ah, it's a 31 the content of cells 31. But what you see is 31.0 and then space and then euro sign.
And you can also choose how many decimal places you want there to be.
And you can choose the currency, of course, And you can. You can have yours for all the countries in Europe that use euros, or it can be in some
other currency. So if you select, for example, pounds in United Kingdom, it will say £31. The fact is that the number still is 31 so you have just chosen
how it's going to be displayed.
So because we're doing euros,
let's, uh, let's go back to euros
with just duty and they will not look for these things. Okay,
so the currencies euro and this box, this cell should be formally dis text. So let's go to form. It sells.
It's general, but we wanted to be text, so we don't want it to be
general format. We just wanted to be a text, and then we say OK,
and, uh and that's it.
And then we have the exchange rate and degenerate is, for example, in the other feet. So we're goingto say here that this is
this cell here
and we have this and we have formula here that says
C two times he too. So this is dollar value. So the
Shane Gray between euro and or is this an Sorry? This should be divided. So I made this minute was preparing. So this makes sense. So 31 you're always 33.99
that should be formatted as
because now we're looking for this.
So let's just leave it like this.
And we have it displayed like it is properly displayed when you have in the dollar value.
So this is it. And now we hear can enter date. So let's say this is this was purchased
on seventh of Remember.
So it's going to be 11 slash seven slash 2019
and we present her and we get this. Now imagine that we're not in United States, that we nurse another country and the numbers are the dates are displayed differently.
So we go here and we have it
said his date and, for example, we want to have the whole year and just leave it like it is. So it's going to be 11 7 2019
However, if we go again to form a ting cells
and then click on some other country,
let's say Germany,
this is it. But
yeah. So this is one away that the date can be represented, but also,
in Germany and in most of Europe,
um, you put the first and then month and then year.
So you get this,
or if you want to go with the full year for month,
choose something like this.
So we have four digits for a year,
and this is how you form it?
A cell. So you're not for mating data in a cell, you're formulating the cell itself.
And then let's say that you have here the number or, for example, he were here. Have ah,
date and you want to display
differently then what is
So then you go to custom,
and then you have a different things and you want it displayed, for example,
year, years year year? No, Sorry.
Um, you wanted, like, they day
hyphen and then month month
and then for
digits for a year,
and it will be displayed. This and this is what a custom data type is.
So you choose how you wanted to be displayed. You put it in the form of thing of a cell. So, for example, here, if you want to change something about
the number of how the number is displayed, you can go to custom,
and then you can have
your way's off defining it. So you can, for example, have it like this, but without comma that separates for thousands. And this is how it looks. So it doesn't change anything. But if we had here 22,000 229
it will be this plate like this.
So without the decimal comma,
you can play with this and you can find the best way to perform at your data and to create your custom data for months if needed. So this this is an example of custom data former, that is not standard in excel.
Ah, and this pretty much concludes this lesson