Excel Magic Trick 1176: CONVERT Function to convert units in Excel (Excel CONVERT Joke at 05:27)

See examples of how to use CONVERT function to convert from one unit to another unit.
1. (00:11) CONVERT function
2. (00:54) Use drop down list to select from_unit and to_unit
3. (02:45) Creating your own units like kilogram for convert function. How do I get kilogram in Convert function
4. (04:03) Use cell references with from_units and to_units
5. (05:27) Joke about using CONVERT function to convert from current religion or philosophy to the desired religion or philosophy

[excelisfun]

Excel Magic Trick 1176: CONVERT Function to convert units in Excel (Excel CONVERT Joke at 05:27)
See examples of how to use CONVERT function to convert from one unit to another unit.
1. (00:11) CONVERT function
2. (00:54) Use drop down list to select from_unit and to_unit
3. (02:45) Creating your own units like kilogram for convert function. How do I get kilogram in Convert function
4. (04:03) Use cell references with from_units and to_units
5. (05:27) Joke about using CONVERT function to convert from current religion or philosophy to the desired religion or philosophy

[pmsocho]

Thanks for showing those prefixes usage and the joke :)

[krn]

Thanks Mike. Didn't even know convert existed.

[MySpreadsheetLab]

Thanks for sharing Mike! Convert function is great!

[garyfrank]

Thanks for sharing this! I cant seem to get the kilo conversion working using k? My version of excel is 16.52, any ideas would be awesome!

[andrewwisnionski]

Hello, I write recipes often for work and I wanted to get them set up for excel conversions. What I want to do is be able to adjust 1 cell, lets call it the multiplier cell on the already built recipe. Lets say the recipe calls for 8Tbsp of something. When I place the multiplier as two, the math would be done and the recipe would print out as 16TBSP now. However I want the document to automatically realize that 16TBSP is also the same as 1C. And instead always print the highest common factor available. Could this be possible, I feel it could with a string of if statements to convert recipes up and up.

[anandkanagaraj]

In my Excel, the drop down menu isn't coming after I insert the convert function and selecting the number. I'm using the Excel 2016; though, I'm not getting that dropdown menu to select the from and to units. Is there any way to bring in those options in my Excel sir?

[scarefiles]

Please Help me Out mike...
How to add Diffrent Units in a single coloumn, if data will like...
Wheat- In Kg
Milk- in Litres
Keyboards- In pcs.

[prudhviraj]

hi sir
I use an application that reports data size usage by date. how it exports its results to excel.

I was wondering if there was a way to right a formula that will ignore the 'B', 'KB', 'MB' and calculate the total data size in MB's or GB's using the 1024b per meg and so on.

If not I was wondering is it possible to create my own custom data type where I can specify the parameters for calculating in data sizes?

Thanks a million in advance!

[allamaprabhuani]

I am trying to convert ksi to MPa, i'm faltering somewhere in the usage of prefixes. How'd you do that?

[papiuniverse]

Hey is there anyway to convert a bunch of data at once like converting 2000 numbers in a row from "mm" to "in"

[aylabilse]

I ounds AND ounces, 10lb. 13oz. I want to convert to decimals, any help?

[erhimanshusingh]

Give shortcut trick about to convert S.I unit into C.G.S and M.K.S system

[ashaydwivedi]

A Little Joke In The End!! Was Very Funny!! CONVERT Cannot Change Who You Are!! Completely =NOT(FALSE)

[louiscordova]

tried going to link for conversion support office

[alaeddin]

Done! Aaaand you're converted! HAHAHA