Need to convert values yet retain the original context of those values? You can convert English to Metric and a lot more with the versatile CONVERT function in Excel! Podcast #1234 examines this useful function..."Excel 2010 In Depth", by Bill Jelen
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel in Depth, chapter 15.
The Convert Function.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
This is one of those functions, that used to be in the analysis tool pack.
So, back in Excel 2003, some people didn't even have this function.
Now, in Excel 2010 and Excel 2007 as part of the core functionality, a pretty good function, if you need to convert from Metric to British units.
So, we need to convert from inches to centimeters, =CONVERT that's asking for three things as asking for the number, that we want to convert and then the from unit and the to unit, and so 123 inches is 312 centimeters.
The other examples here, if we need to convert from pound's mass, LBM to the kilograms, from fahrenheit to celsius, tablespoons to teaspoons.
Now, you'll see that as you enter this function, when you get out here.
They have a list of all the different possible abbreviations.
I actually prefer to go to excel help, to check this out.
So, usually what I do is I do, =CONVERT and then hit the fx button here, help on this function.
Which will get me to the Excel help topic, which shows me all of the different things.
So, distance, meters to miles, nautical miles to statute miles, angstroms the picas.
Time, I can go from year to seconds, from pascals to atmospheres, newtons to dyns, joules to ergs, horse powers to watt, tesla to gauss.
Centigrade to fahrenheit, teaspoons to tablespoons, U.S pints to U.K pints, and then of course all the metric abbreviations work as well.
So, the important thing here you need to get the abbreviation correct including case.
It is case sensitive, to be careful when you're doing that.
But, the convert function very cool function, and we'll do a lot of different conversions for you.
One question, I get all the time is that, hey! Can I do currency conversions?
No! Doesn't do that.
But, as far as measures...
Well, thank you for stopping by.
I will see you next time for another netcast, from MrExcel.
Excel in Depth, chapter 15.
The Convert Function.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
This is one of those functions, that used to be in the analysis tool pack.
So, back in Excel 2003, some people didn't even have this function.
Now, in Excel 2010 and Excel 2007 as part of the core functionality, a pretty good function, if you need to convert from Metric to British units.
So, we need to convert from inches to centimeters, =CONVERT that's asking for three things as asking for the number, that we want to convert and then the from unit and the to unit, and so 123 inches is 312 centimeters.
The other examples here, if we need to convert from pound's mass, LBM to the kilograms, from fahrenheit to celsius, tablespoons to teaspoons.
Now, you'll see that as you enter this function, when you get out here.
They have a list of all the different possible abbreviations.
I actually prefer to go to excel help, to check this out.
So, usually what I do is I do, =CONVERT and then hit the fx button here, help on this function.
Which will get me to the Excel help topic, which shows me all of the different things.
So, distance, meters to miles, nautical miles to statute miles, angstroms the picas.
Time, I can go from year to seconds, from pascals to atmospheres, newtons to dyns, joules to ergs, horse powers to watt, tesla to gauss.
Centigrade to fahrenheit, teaspoons to tablespoons, U.S pints to U.K pints, and then of course all the metric abbreviations work as well.
So, the important thing here you need to get the abbreviation correct including case.
It is case sensitive, to be careful when you're doing that.
But, the convert function very cool function, and we'll do a lot of different conversions for you.
One question, I get all the time is that, hey! Can I do currency conversions?
No! Doesn't do that.
But, as far as measures...
Well, thank you for stopping by.
I will see you next time for another netcast, from MrExcel.
