Excel Magic Trick 1176

CONVERT Function to convert units in Excel

DESCRIPTION

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