CONVERT

The CONVERT function converts a number from one measurement system to its corresponding value in another measurement system.

Examples
=CONVERT(9, “lbm”, “kg”) returns 4.08233133 (9 pounds is approximately 4.08 kilograms). =CONVERT (26.2, “mi”, “m”) returns 42,164.8128 (26.2 miles is approximately 42, 164.8 meters). =CONVERT(1, “tsp”, “ml”) returns 4.92892159375 (1 teaspoon is approximately 4.9 milliliters).

Weight and mass units

The table below shows the supported units of measure for weight and mass, and the constant to use for each.

Unit of measure	Constant
Gram	“g” (can be used with metric prefixes)
Slug	“sg”
Pound mass (avoirdupois)	“lbm” or “lb”
U (atomic mass unit)	“u” (can be used with metric prefixes)
Ounce mass (avoirdupois)	“ozm”
Grain	"grain”
U.S. hundredweight	"cwt”
U.S. (short) hundredweight	"shweight”
Imperial hundredweight	"uk_cwt” or “lcwt” (“hweight”)
Stone	"stone”
Ton	"ton”
Imperial ton	"uk_ton” or “LTON” (“brton”)

The table below shows the supported units of measure for distance, and the constant to use for each.

Measure	Constant
Meter	“m” (can be used with metric prefixes)
Statute mile	“mi”
Nautical mile	“Nmi”
Inch	“in”
Foot	“ft”
Yard	“yd”
Angstrom	“ang” (can be used with metric prefixes)
Pica (1/6 inch)	“Pica”
Ell	"ell”
Lightyear	"ly”
Parsec	"parsec” or “pc”
U.S. survey mile	"survey_mi”

Measure	Constant
Year	“yr”
Week	“wk”
Day	“day”
Hour	“hr”
Minute	“mn”
Second	“sec” (can be used with metric prefixes)

The table below shows the supported units of measure for speed, and the constant to use for each.

Measure	Constant
Miles per hour	“mi/h” or “mph”
Miles per minute	“mi/mn”
Meters per hour	“m/h” or “m/hr”(can be used with metric prefixes)
Meters per minute	“m/mn” (can be used with metric prefixes)
Meters per second	“m/s” or “m/sec” (can be used with metric prefixes)
Feet per minute	“ft/mn”
Feet per second	“ft/s”
Knot	“kt” or “kn”
Admiralty knot	“admkn”

The table below shows the supported units of measure for pressure, and the constant to use for each.

Measure	Constant
Pascal	“Pa” or “p” (can be used with metric prefixes)
Atmosphere	“atm” or “at” (can be used with metric prefixes)
Millimeters of mercury	“mmHg” (can be used with metric prefixes)
PSI	"psi”
Torr	"Torr”

Measure	Constant
Newton	“N” (can be used with metric prefixes)
Dyne	“dyn” or “dy” (can be used with metric prefixes)
Pound force	“lbf”
Pond	"pond”

The table below shows the supported units of measure for energy, and the constant to use for each.

Measure	Constant
Joule	“J” (can be used with metric prefixes)
Erg	“e” (can be used with metric prefixes)
Thermodynamic calorie	“c” (can be used with metric prefixes)
IT calorie	“cal” (can be used with metric prefixes)
Electron volt	“eV” or “ev” (can be used with metric prefixes)
Horsepower-hour	“HPh” or “hh”
Watt-hour	“Wh” or “wh” (can be used with metric prefixes)
Foot-pound	“flb”
BTU	“BTU” or “btu”

Measure	Constant
Horsepower	“HP” or “h”
Pferdestärke	"PS”
Watt	“W” or “w” (can be used with metric prefixes)

Measure	Constant
Tesla	“T” (can be used with metric prefixes)
Gauss	“ga” (can be used with metric prefixes)

Measure	Constant
Degrees Celsius	“C” or “cel”
Degrees Fahrenheit	“F” or “fah”
Kelvin	“K” or “kel” (can be used with metric prefixes)
Degrees Rankine	"Rank”
Degrees Réaumur	"Reau”

The table below shows the supported units of measure for liquid, and the constant to use for each.

Measure	Constant
Teaspoon	“tsp”
Modern teaspoon	"tspm”
Tablespoon	“tbs” or “tbsp”
Fluid ounce	“oz” or “fl oz”
Cup	“cup”
U.S. pint	“pt”
U.K. pint	“uk_pt”
Quart	“qt”
Imperial quart (U.K.)	"uk_qt”
Gallon	“gal”
Imperial gallon (U.K.)	"uk_gal”
Liter	“l” or “L” (“lt”) (can be used with metric prefixes)
Cubic angstrom	"ang3” or “ang^3”
U.S. oil barrel	"barrel”
U.S. bushel	"bushel”
Cubic feet	"ft3” or “ft^3”
Cubic inch	"in3” or “in^3”
Cubic light-year	"ly3” or “ly^3”
Cubic meter	"m3” or “m^3”
Cubic yard	"yd3” or “yd^3”
Cubic nautical mile	"Nmi3” or “Nmi^3”
Cubic pica	"Picapt3” or “Picapt^3” or ”Pica3” or “Pica^3”
Gross ton	"GRT” or “regton”
Freight ton	"MTON”

The table below shows the supported units of measure for area, and the constant to use for each.

Measure	Constant
International acre	“uk_acre”
U.S. acre	“us_acre”
Square angstrom	"ang2” or “ang^2”
Are	"ar”
Square feet	"ft2” or “ft^2”
Hectare	"ha”
Square inch	"in2” or “in^2”
Square lightyear	"ly2” or “ly^2”
Square meter	"m2” or “m^2”
Morgen	"Morgen”
Square mile	"mi2” or “mi^2”
Square nautical mile	"Nmi2” or “Nmi^2”
Square pica	"Picapt2” or “Picapt^2” or ”Pica2” or “Pica^2”
Square yard	"yd2” or “yd^2”

Measure	Constant
Bit	“bit” (can be used with metric prefixes)
Byte	“byte” (can be used with metric prefixes)

The table below shows the supported metric prefixes, and the constant to use for each.