Table of Contents

Microsoft Excel - Convert - Convert Function

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)

where:


CONVERT accepts the following text values (in quotation marks) for from_unit and to_unit.

Weight and massFrom_unit or to_unit
Gram“g”
Slug“sg”
Pound mass (avoirdupois)“lbm”
U (atomic mass unit)“u”
Ounce mass (avoirdupois)“ozm”
Grain“grain”
U.S. (short) hundredweight“cwt” or “shweight”
Imperial hundredweight“uk_cwt” or “lcwt” (“hweight”)
Stone“stone”
Ton“ton”
Imperial ton“uk_ton” or “LTON” (“brton”)
DistanceFrom_unit or to_unit
Meter“m”
Statute mile“mi”
Nautical mile“Nmi”
Inch“in”
Foot“ft”
Yard“yd”
Angstrom“ang”
Ell“ell”
Light-year“ly”
Parsec“parsec” or “pc”
Pica (1/72 inch)“Picapt” or “Pica”
Pica (1/6 inch)“pica”
U.S survey mile (statute mile)“survey_mi”
TimeFrom_unit or to_unit
Year“yr”
Day“day” or “d”
Hour“hr”
Minute“mn” or “min”
Second“sec” or “s”
PressureFrom_unit or to_unit
Pascal“Pa” (or “p”)
Atmosphere“atm” (or “at”)
mm of Mercury“mmHg”
PSI“psi”
Torr“Torr”
ForceFrom_unit or to_unit
Newton“N”
Dyne“dyn” (or “dy”)
Pound force“lbf”
Pond“pond”
EnergyFrom_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”)
PowerFrom_unit or to_unit
Horsepower“HP” (or “h”)
Pferdestärke“PS”
Watt“W” (or “w”)
MagnetismFrom_unit or to_unit
Tesla“T”
Gauss“ga”
TemperatureFrom_unit or to_unit
Degree Celsius“C” (or “cel”)
Degree Fahrenheit“F” (or “fah”)
Kelvin“K” (or “kel”)
Degrees Rankine“Rank”
Degrees Réaumur“Reau”
Volume (or liquid measure )From_unit or to_unit
Teaspoon“tsp”
Modern teaspoon“tspm”
Tablespoon“tbs”
Fluid ounce“oz”
Cup“cup”
U.S. pint“pt” (or “us_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”)
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 Mile“mi3” or “mi^3”
Cubic yard“yd3” or “yd^3”
Cubic nautical mile“Nmi3” or “Nmi^3”
Cubic Pica“Picapt3”, “Picapt^3”, “Pica3” or “Pica^3”
Gross Registered Ton“GRT” (“regton”)
Measurement ton (freight ton)“MTON”
AreaFrom_unit or to_unit
International acre“uk_acre”
U.S. survey/statute acre“us_acre”
Square angstrom“ang2” or “ang^2“
Are“ar”
Square feet“ft2” or “ft^2”
Hectare“ha”
Square inches“in2” or “in^2”
Square light-year“ly2” or “ly^2”
Square meters“m2” or “m^2”
Morgen“Morgen”
Square miles“mi2” or “mi^2”
Square nautical miles“Nmi2” or “Nmi^2”
Square Pica“Picapt2”, “Pica2”, “Pica^2” or “Picapt^2”
Square yards“yd2” or “yd^2”
InformationFrom_unit or to_unit
Bit“bit”
Byte“byte”
SpeedFrom_unit or to_unit
Admiralty knot“admkn”
Knot“kn”
Meters per hour“m/h” or “m/hr”
Meters per second“m/s” or “m/sec”
Miles per hour“mph”

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

PrefixMultiplierAbbreviation
yotta1E+24“Y”
zetta1E+21“Z”
exa1000000000000000000“E”
peta1000000000000000“P”
tera1000000000000“T”
giga1000000000“G”
mega1000000“M”
kilo1000“k”
hecto100“h”
dekao10“da” or “e”
deci0.1“d”
centi0.01“c”
milli0.001“m”
micro0.000001“u”
nano0.000000001“n”
pico0.000000000001“p”
femto0.000000000000001“f”
atto0.000000000000000001“a”
zepto1E-21“z”
yocto1E-24“y”
Binary PrefixPrefix ValueAbbreviationDerived from
yobi2^80 = 1 208 925 819 614 629 174 706 176“Yi”yotta
zebi2^70 = 1 180 591 620 717 411 303 424“Zi”zetta
exbi2^60 = 1 152 921 504 606 846 976“Ei”exa
pebi2^50 = 1 125 899 906 842 624“Pi”peta
tebi2^40 = 1 099 511 627 776“Ti”tera
gibi2^30 = 1 073 741 824“Gi”giga
mebi2^20 = 1 048 576“Mi”mega
kibi2^10 = 1024“ki”kilo

Remarks

Unit names and prefixes are case-sensitive.


Example

FormulaDescriptionResult
=CONVERT(1, “lbm”, “kg”)Converts 1 pound mass to kilograms.0.4535924
=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