- Excel Book Excerpt
Excel Convert Units
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
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.
Figure 380 CONVERT handles many conversion factors.
For more resources for Microsoft Excel: