Let Excel Help You Easily Make Metric Conversions

Have you ever had to convert miles to kilometers…inches to centimeters…gallons to liters…Fahrenheit degrees to Celsius degrees…or some other measurement unit?

Well, Excel can help you quickly and easily convert these measurement units.

For Excel 2007/2010 users:

  1. Open Excel and then click the Office Button in 2007 (click File tab in 2010)
  2. Click Excel Options button
  3. Click Add-Ins on the left
  4. Click on Analysis ToolPak from list
  5. Make sure Excel Add-Ins is selected in the Manage box
  6. Click Go
  7. Click to put a check mark in the box next to Analysis ToolPak and then click OK to return to your Excel worksheet

For Excel 2003 (or earlier) users:

  1. Open Excel
  2. Go to the Tools menu
  3. Select Add-Ins
  4. Select the Analysis ToolPak check box
  5. Click OK

For example if you want to convert 2 1/2 pounds to kilograms, use the following Excel function:

=CONVERT(2.5, “lbm”, “kg”) Your answer should be 1.133981. To find the kilogram equivalent of 1 pound, just replace 2.5 in the formula with 1.0, which should yield a result of 0.453592.

For a complete list of measurement unit conversions available in Excel, visit the following Microsoft web site:


For more information, contact Becky Jones, Associate Dean, bjones@dcccd.edu 972-238-6215.