Excel In Depth 15 - Convert Function

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jul 14, 2010.
Convert English to Metric and more with the versatile CONVERT function.
maxresdefault.jpg


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.
Well, 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, it’s part of the core functionality.
A pretty good function if you need to convert from Metric to British units.
So, if we need to convert from inches to centimeters, =CONVERT, that's asking for three things.
It’s asking for the number that we want to convert, and then the from_unit, and the to_unit.
And so 123 In is 312 cm.
The other examples here, if we need to convert from pounds mass lbm, the kilograms, from Fahrenheit to Celsius, from 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 to Picas, time.
I can go from year to seconds, from Pascals to Atmospheres, Newtons to Dynes, Joules to Ergs, Horsepowers to Watts, Tesla to Gauss, centigrade to Fahrenheit, teaspoons to tablespoons, US pints to UK 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, so be careful when you're doing that, but the CONVERT function, very cool function, it will do a lot of different conversions for you.
One question I get all the time is “Hey, can it do currency conversions?” No, it doesn't do that, but as far as measures… (unclear) Want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel!
 

Forum statistics

Threads
1,213,490
Messages
6,113,957
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top