Excel includes the CONVERT function as part of its Analysis ToolPak add-in. The Analysis ToolPak is included with Excel, and it’s a breeze to install.

To install the Analysis ToolPak add-in:

  1. Choose Tools | Add-ins from the menu bar. (In 2007, click on the Office button and choose Excel Options, then click on Add-Ins, then click Go. In 2010, select the File tab and choose Options, then click on Add-Ins, then click Go.)
  2. In the Add-ins dialog box, select the check box next to Analysis ToolPak in the list box and click OK.

To convert miles to kilometers:

  1. Select cell E5 and type =CONVERT(.
  2. Click the Paste Function button to access the Function Arguments window.
  3. Select cell D5, which holds the value you wish to convert, so the cell reference appears in the Number text box.
  4. Press [Tab] and enter mi in the From_Unit text box.
  5. Press [Tab], enter km in the To_Unit text box, and click OK.
  6. Select cell E5 and drag its fill handle down to cell E9 to apply the formula to the other cells.
  7. Select the range E5:E9 and click the Decrease Decimal button on the Formatting toolbar until the values display in tenths of a kilometer.

The CONVERT function also converts units of measurement for mass, pressure, liquid, and many others. For a complete list, along with the unit abbreviations accepted by the function, type CONVERT in Excel’s Help window.

Once you create a worksheet based on our example, you can use the CONVERT function to instantly perform the conversions from miles to kilometers.

Advertisements