### Convert Measurements in Excel

### Convert Measurements in Excel

The CONVERT function is used to convert measurements from one set of units to another in Excel.

For example, the CONVERT function can be used to convert degrees Celsius to degrees Fahrenheit, hours to minutes, or meters to feet.

A complete list of units and their shortforms that can be used with this function is available on page two of the tutorial.

The syntax for the CONVERT function is:

**=CONVERT ( Number, From_Unit, To_Unit )**

Number - the value to be converted.

From_Unit - the shortform of the Number's current measurement unit.

To_Unit - the shortform of the measurement unit the Number will be converted to.

When choosing units for conversion, it is the shortforms that are entered as the

*From_Unit*

and

*To_Unit*

for the function.

### Convert Measurements in Excel Example

In the example shown in the image above, we will convert a measurement of 3.4 meters to an equivalent distance in feet.

**Note:** The instructions for copying the data do not include formatting steps for the worksheet.

This will not interfere with completing the tutorial. Your worksheet may look different than the example shown, but the CONVERT function will give you the same results.

- Enter the data into cells C1 to D4 of an Excel worksheet as seen in the image above.
- Click on cell E4 - this is where the results of the function will be displayed.
- Click on the
*Formulas*tab of the ribbon menu. - Choose
**More Functions > Engineering**from the ribbon to open the function drop down list. - Click on
*CONVERT*in the list to bring up the function's dialog box. - In the dialog box, click on the
*Number*line. - Click on cell E3 in the worksheet to enter that cell reference into the dialog box.
- In the dialog box, click on the
*From_Unit*line. - Click on cell D3 in the worksheet to enter that cell reference.
- In the dialog box, click on the
*To_Unit*line. - Click on cell D4 in the worksheet to enter that cell reference.
- Click OK.
- The answer 11.15485564 should appear in cell E4.
- To make it easier to read the answer, the number of decimal places displayed in cell E4 can be reduced by using the Decreasing Decimal Places option available on the Home tab of the ribbon.
- When you click on cell E4 the complete function
**=CONVERT( E3, D3, D4)**appears in the formula bar above the worksheet. - To convert other distances from meters to feet, change the value in cell E3.
- To convert values using different units, enter the units' shortforms in cells D3 and D4 and the value to be converted in cell E3.

**Related Tutorials**

### CONVERT Function Measurement Units and Their Shortforms

Below is a list of unit shortforms that can be used with Excel's CONVERT function.

These shortforms are entered as the *From_Unit* or *To_Unit* argument for the function.

The shortforms can be typed directly into the appropriate line in the dialog box or the cell reference to the location of the shortform in the worksheet can be used.

For an example of how to use these shortforms in the CONVERT function see page 1 of this tutorial.

### Time

Year - "yr" Day - "day" Hour - "hr" Minute - "mn" Second - "sec"

### Temperature

Degree (Celsius) - "C" or "cel" Degree (Fahrenheit) - "F" or "fah" Degree (Kelvin) - "K" or "kel"

### Distance

Meter - "m" Mile (statute) - "mi" Mile (nautical) - "Nmi" Inch - "in" Foot - "ft" Yard - "yd" Angstrom - "ang" Pica - "pica"

### Liquid Measure

Liter - "l" or "lt" Teaspoon - "tsp" Tablespoon - "tbs" Fluid ounce - "oz" Cup - "cup" Pint (U.S.) - "pt" or "us_pt" Pint (U.K.) - "uk_pt" Quart - "qt" Gallon - "gal"

### Weight and Mass

Gram - "g" Pound mass (avoirdupois) - "lbm" Ounce mass (avoirdupois) - "ozm" U (atomic mass unit) - "u" Slug - "sg"

### Pressure

Pascal - "Pa" or "p" Atmosphere - "atm" or "at" mm of Mercury - "mmHg"

### Force

Newton - "N" Dyne - "dyn" or "dy" Pound force - "lbf"

### Power

Horsepower - "h" or "HP" Watt - "w" or "W"

### Energy

Joule - "J" Erg - "e" Calorie (thermodynamic) - "c" Calorie (IT) - "cal" Electron volt - "ev" or "eV" Horsepower-hour - "hh" or "HPh" Watt-hour - "wh" or "Wh" Foot-pound - "flb" BTU - "btu" or "BTU"

### Magnetism

Tesla - "T" Gauss - "ga"

### Metric Unit Shortforms

For metric units, the only change to a unit's name as it decreases or increases in size is the prefix used n front of the name - such as *centi*meter for 0.1 meters or *kilo*meter for 1,000 meters.

Given this, below is a list of single letter prefixes that can be placed in front of any metric unit shortform listed above to change the units used in either the *From_Unit* or *To_Unit* arguments.

Examples:

- for distances, to covert miles to kilometers rather than meters, use
*km*instead of*m*. - for weights, to covert ounces to milligrams rather than grams, use
*mg*instead of*g*.

**Note:** Some of the prefixes must be entered in upper case as shown below.

Prefix - Shortform exa - "E" peta - "P" tera - "T" giga - "G" mega - "M" kilo - "k" hecto - "h" dekao - "e" deci - "d" centi - "c" milli - "m" micro - "u" nano - "n" pico - "p" femto - "f" atto - "a"