to-unit: A string value representing the new unit of the number to be converted. It must be one of the constants specified in the tables below.
The possible values for from-unit and to-unit are shown in the tables below, organized by category. If you enter a value in a referenced cell, instead of typing it directly into the function, you don’t need to enclose it in quotation marks. The values are case-sensitive; use the exact capitalization shown in the tables.
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).
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
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"
The table below shows the supported units of measure for duration, and the constant to use for each.
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.
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.
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"
The table below shows the supported units of measure for force, and the constant to use for each.
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.
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"
The table below shows the supported units of measure for power, and the constant to use for each.
Horsepower
"HP" or "h"
Pferdestärke
"PS"
Watt
"W" or "w" (can be used with metric prefixes)
The table below shows the supported units of measure for magnetism, and the constant to use for each.
Tesla
"T" (can be used with metric prefixes)
Gauss
"ga" (can be used with metric prefixes)
The table below shows the supported units of measure for temperature, and the constant to use for each.
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.
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.
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"
The table below shows the supported units of measure for information, and the constant to use for each.
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.
Multiplier
yotta
"Y"
1E+24
zetta
"Z"
1E+21
exa
"E"
1E+18
peta
"P"
1E+15
tera
"T"
1E+12
giga
"G"
1E+09
mega
"M"
1E+06
kilo
"k"
1E+03
hecto
"h"
1E+02
deca
"e"
1E+01
deci
"d"
1E-01
centi
"c"
1E-02
milli
"m"
1E-03
micro
"u" or "µ"
1E-06
nano
"n"
1E-09
pico
"p"
1E-12
femto
"f"
1E-15
atto
"a"
1E-18
zepto
"z"
1E-21
yocto
"y"
1E-24
The table below shows the supported binary prefixes, and the constant to use for each.
yobi
"Yi"
2^80
zebi
"Zi"
2^70
exbi
"Ei"
2^60
pebi
"Pi"
2^50
tebi
"Ti"
2^40
gibi
"Gi"
2^30
mebi
"Mi"
2^20
kibi
"ki"
2^10