I'm going to talk today about using the convert function in Excel to convert
metric measurements to imperial measurement I live in Canada and we use
the metric system and quite often I'm doing contracts for people in countries
that still use the imperial system so I have to quite often do this so I'm gonna
for example change kilometers and I've got 10 kilometers and I'm gonna change
it to how many miles it is so what we're gonna do is we're gonna click and cell
next to the miles and we're gonna go equals and we're going to type in
convert okay so now what we're going to do is we're gonna select the ten and
then we're gonna put a comma in there and it's asking what unit of
measurement we're using and I'm using a kilometers but they don't have
kilometers so I'm going to select meters
now what I'm going to do because kilometer is a thousand meters and you
just put a small K in front of the M here and then I'm gonna put a comma and
then I'm gonna select miles now they're miles are listed as Statue miles and so
we're I'm gonna double click this and so there we go and I'm gonna press ENTER
and so 10 kilometers works out to six point two ordered to one three miles so
now let's do the same thing for kilograms so now I'm going to select I
new convert kilograms to pounds so I have 10 kilograms here and how many
pounds does that work out - so I go equals convert now I select my 10 and
I'm gonna put a comma and I'm gonna select grounds
I'm sorry grams now similar to the kilometers we have to just put a K in
front of it to indicate a thousand so we have kilograms
and I'm gonna put a comma in here and I'm going to select the pound mass right
here and I'm going to close my bracket and I'm going to go enter so that is 10
kilograms equals 22 point zero four pounds now let's go meters to feet so
now let's go equals and I'm going to select my tan and I'm gonna select
meters and I put another comment and then I've got foot there you go
ten meters equals thirty two point eight eight so the next one I'm gonna do is
I'm going to do square meters two square feet so I'm just gonna drag this down
because we've already calculated up here for the ten and now I've got it for one
so basically all we have to do then is you know back back to your elementary
math you have to square both sides so one square feet and you square this so
let's let's go in here and it equals this and we're gonna put the symbol for
the square and we're gonna press Enter so one square meter is equal to ten
point seven six square feet so that's how you do the simple conversions from
metric to imperial systems with the convert function in excel please
subscribe