﻿ CONVERT function

# CONVERT function

This article describes the formula syntax and usage of the CONVERTfunction in Microsoft Excel.

## Description

Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

## Syntax

CONVERT(number, from_unit, to_unit)

The CONVERT function syntax has the following arguments:

• Number    Required. The value in from_units to convert.

• From_unit    Required. The units for number.

• To_unit    Required. The units for the result. CONVERT accepts the following text values (in quotation marks) for from_unit and to_unit.

 Weight and mass From_unit or to_unit Gram "g" Slug "sg" Pound mass (avoirdupois) "lbm" U (atomic mass unit) "u" Ounce mass (avoirdupois) "ozm"
 Distance From_unit or to_unit Meter "m" Statute mile "mi" Nautical mile "Nmi" Inch "in" Foot "ft" Yard "yd" Angstrom "ang" Pica "pica"
 Time From_unit or to_unit Year "yr" Day "day" Hour "hr" Minute "mn" Second "sec"
 Pressure From_unit or to_unit Pascal "Pa" (or "p") Atmosphere "atm" (or "at") mm of Mercury "mmHg"
 Force From_unit or to_unit Newton "N" Dyne "dyn" (or "dy") Pound force "lbf"
 Energy From_unit or to_unit Joule "J" Erg "e" Thermodynamic calorie "c" IT calorie "cal" Electron volt "eV" (or "ev") Horsepower-hour "HPh" (or "hh") Watt-hour "Wh" (or "wh") Foot-pound "flb" BTU "BTU" (or "btu")
 Power From_unit or to_unit Horsepower "HP" (or "h") Watt "W" (or "w")
 Magnetism From_unit or to_unit Tesla "T" Gauss "ga"
 Temperature From_unit or to_unit Degree Celsius "C" (or "cel") Degree Fahrenheit "F" (or "fah") Kelvin "K" (or "kel")
 Liquid measure From_unit or to_unit Teaspoon "tsp" Tablespoon "tbs" Fluid ounce "oz" Cup "cup" U.S. pint "pt" (or "us_pt") U.K. pint "uk_pt" Quart "qt" Gallon "gal" Liter "l" (or "lt")

The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit.

 Prefix Multiplier Abbreviation exa 1E+18 "E" peta 1E+15 "P" tera 1E+12 "T" giga 1E+09 "G" mega 1E+06 "M" kilo 1E+03 "k" hecto 1E+02 "h" dekao 1E+01 "e" deci 1E-01 "d" centi 1E-02 "c" milli 1E-03 "m" micro 1E-06 "u" nano 1E-09 "n" pico 1E-12 "p" femto 1E-15 "f" atto 1E-18 "a"

## Remarks

• If the input data types are incorrect, CONVERT returns the #VALUE! error value.

• If the unit does not exist, CONVERT returns the #N/A error value.

• If the unit does not support an abbreviated unit prefix, CONVERT returns the #N/A error value.

• If the units are in different groups, CONVERT returns the #N/A error value.

• Unit names and prefixes are case-sensitive.

## Example

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

How do I copy an example?

Important   Do not select the row or column headers.

Selecting an example from Help

2. Press CTRL+C.

3. In Excel, create a blank workbook or worksheet.

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

Important   For the example to work properly, you must paste it into cell A1 of the worksheet.

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.

After you copy the example to a blank worksheet, you can adapt it to suit your needs.

 1 2 3 4 5
 A B Formula Description (Result) =CONVERT(1.0, "lbm", "kg") Converts 1 pound mass to kilograms (0.453592) =CONVERT(68, "F", "C") Converts 68 degrees Fahrenheit to Celsius (20) =CONVERT(2.5, "ft", "sec") Data types are not the same so an error is returned (#N/A) =CONVERT(CONVERT(100,"ft","m"),"ft","m") Converts 100 square feet into square meters (9.290304).

Applies To: Excel 2010, Excel Starter, Excel Online, SharePoint Online

﻿