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:

number: is the value in from_units to convert.
from_unit: is the units for number.
to_unit: is 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”
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”)

Distance	From_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”

Time	From_unit or to_unit
Year	“yr”
Day	“day” or “d”
Hour	“hr”
Minute	“mn” or “min”
Second	“sec” or “s”

Pressure	From_unit or to_unit
Pascal	“Pa” (or “p”)
Atmosphere	“atm” (or “at”)
mm of Mercury	“mmHg”
PSI	“psi”
Torr	“Torr”

Force	From_unit or to_unit
Newton	“N”
Dyne	“dyn” (or “dy”)
Pound force	“lbf”
Pond	“pond”

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”)
Pferdestärke	“PS”
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”)
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”

Area	From_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”

Information	From_unit or to_unit
Bit	“bit”
Byte	“byte”

Speed	From_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.

Prefix	Multiplier	Abbreviation
yotta	1E+24	“Y”
zetta	1E+21	“Z”
exa	1000000000000000000	“E”
peta	1000000000000000	“P”
tera	1000000000000	“T”
giga	1000000000	“G”
mega	1000000	“M”
kilo	1000	“k”
hecto	100	“h”
dekao	10	“da” or “e”
deci	0.1	“d”
centi	0.01	“c”
milli	0.001	“m”
micro	0.000001	“u”
nano	0.000000001	“n”
pico	0.000000000001	“p”
femto	0.000000000000001	“f”
atto	0.000000000000000001	“a”
zepto	1E-21	“z”
yocto	1E-24	“y”

Binary Prefix	Prefix Value	Abbreviation	Derived from
yobi	2^80 = 1 208 925 819 614 629 174 706 176	“Yi”	yotta
zebi	2^70 = 1 180 591 620 717 411 303 424	“Zi”	zetta
exbi	2^60 = 1 152 921 504 606 846 976	“Ei”	exa
pebi	2^50 = 1 125 899 906 842 624	“Pi”	peta
tebi	2^40 = 1 099 511 627 776	“Ti”	tera
gibi	2^30 = 1 073 741 824	“Gi”	giga
mebi	2^20 = 1 048 576	“Mi”	mega
kibi	2^10 = 1024	“ki”	kilo

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 a binary 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

Formula	Description	Result
=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

Wiki

Table of Contents

Microsoft Excel - Convert - Convert Function

Syntax

Remarks

Example