Convert Units

March 14, 2022 - by Bill Jelen

Problem: I need to convert units of measure. I can never remember that there are .453 kilograms in a pound or 2.54 centimeters in an inch.

Strategy: You can use the CONVERT function to convert a certain number of one unit to another unit. The CONVERT function works with units of weight, distance, time, pressure, force, energy, power, magnetism, temperature, and liquid measure.

The syntax for this function is =CONVERT(number, from unit, to unit). It’s important that you use the correct abbreviations (for example, lbm for pounds mass), so look in Excel help if you need to.

This figure shows a sampling of the conversions possible with this function.

The CONVERT function handles hundreds of unit conversions. Shown here are a few, such as Pounds to kilograms, years to seconds, Fahrenheit to Celsius, Inches to Centimeters. — Figure 375. CONVERT handles many conversion factors.

This article is an excerpt from Power Excel With MrExcel

Title photo by William Warby on Unsplash