﻿ Convert measurements

# Convert measurements

Let's say you want to know how many kilometers that you ran on a quarter-mile track or a tolerance level using metric values. To convert measurements, use the CONVERT function. The CONVERT function converts a wide range of measurements, including measures of weight, distance, time, pressure, force, energy, power, magnetism, temperature, and liquid measure.

## Example

The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

1. Create a blank workbook or worksheet.

2. Select the example in the Help topic.

Note   Do not select the row or column headers.

Selecting an example from Help

3. Press CTRL+C.

4. In the worksheet, select cell A1, and press CTRL+V.

5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

 1 2
 A Data 6 Formula Description (Result) =CONVERT(A2,"C","F") Convert 6 degrees Celsius to Fahrenheit (42.8) =CONVERT(A2,"tsp","tbs") Convert 6 teaspoons to tablespoons (2) =CONVERT(A2,"gal","l") Convert 6 gallons to liters (22.71741274) =CONVERT(A2,"mi","km") Convert 6 miles to kilometers (9.656064) =CONVERT(A2,"km","mi") Convert 6 kilometers to miles (3.728227153) =CONVERT(A2,"in","ft") Convert 6 inches to feet (0.5) =CONVERT(A2,"cm","in") Convert 6 centimeters to inches (2.362204724)

Note   To see a full list of all the measures that can be converted, see the CONVERT function help topic.

## Function details

Applies To: Excel 2010

﻿