# 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.

1. Create a blank workbook or worksheet.
1. Select the example in the Help topic.

Note   Do not select the row or column headers.

Selecting an example from Help
1. Press CTRL+C.
1. In the worksheet, select cell A1, and press CTRL+V.
1. 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.
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.

CONVERT function

Applies to:
Excel 2010