Home » ExcelBuiltInFunctions » ExcelEngineeringFunctions » ExcelConvertFunction
The Excel CONVERT Function
Function Description
The Excel CONVERT function converts a number from one unit type (e.g. Yards) to another unit type (e.g. Meters). The function is new to Excel 2007, so is not available in earlier versions of Excel.
The syntax of the function is:
CONVERT( number, from_unit, to_unit )
Where the arguments are as follows:
number    The number to be converted. 
from_unit    A text string, denoting the current unit for the original number. 
to_unit    A text string, denoting the unit that you want to convert the original number to. 
The from_unit and to_unit arguments provided to the Excel Convert function must be compatible. I.e. they must not be from different measurement types (e.g. temperature & distance). If you attempt to convert between two incompatible measurement types, Excel will return the #N/A error.
The tables below show the different measurement types that the Excel Convert Function understands, and the text abbreviations that must be supplied to the function to denote each unit type. Note that:
 The text abbreviations for the unit types are case sensitive;
 The unit types that are colored in red were introduced in Excel 2013 and so are not available in earlier versions of Excel.
Distance Units 

Meter  "m"  Statute Mile  "mi"  Nautical Mile  "Nmi"  Inch  "in"  Foot  "ft"  Yard  "yd"  Angstrom  "ang"  Pica (1/6 inch)  "pica"  Pica (1/72 inch)  "Pica" (or "Picapt")  Ell  "ell"  Lightyear  "ly"  Parsec  "parsec" (or "pc")  U.S. survey mile  "survey_mi"   Area Units 

International acre  "uk_acre"  U.S. survey 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 lightyear  "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" (or "Pica2" or "Pica^2" or "Picapt^2")  Square yards  "yd2" (or "yd^2")   Liquid Units 

Teaspoon  "tsp"  Tablespoon  "tbs"  Fluid Ounce  "oz"  Cup  "cup"  U.S. Pint  "pt" (or "us_pt")  U.K. Pint  "uk_pt"  Quart  "qt"  Imperial quart  "uk_qt"  Gallon  "gal"  Imperial gallon  "uk_gal"  Liter  "l" (or "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 lightyear  "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" (or "Picapt^3" or "Pica3" or "Pica^3")  Gross Registered Ton  "GRT" (or "regton")  Measurement ton  "MTON"   Power Units 

Horsepower  "HP" (or "h")  Watt  "W" (or "w")  Pferdestärke  "PS"   Magnetism Units 

Tesla  "T"  Gauss  "ga" 
 Time Units 

Year  "yr"  Day  "day"  Hour  "hr"  Minute  "mn"  Second  "sec"   Speed Units 

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"   Weight & Mass Units 

Gram  "g"  Slug  "sg"  Pound Mass  "lbm"  U (Atomic Mass Unit)  "u"  Ounce Mass  "ozm"  Grain  "grain"  U.S. hundredweight  "cwt" (or "shweight")  Imperial hundredweight  "uk_cwt" (or "lcwt" or "hweight")  Stone  "stone"  Ton  "ton"  Imperial ton  "uk_ton" (or "LTON" or "brton")   Force Units 

Newton  "N"  Dyne  "dyn" (or "dy")  Pound Force  "lbf"  Pond  "pond"   Pressure Units 

Pascal  "Pa" (or "p")  Atmosphere  "atm" (or "at")  mm of Mercury  "mmHg"  PSI  "psi"  Torr  "Torr"   Temperature Units 

Degree Celsius  "C" (or "cel")  Degree Fahrenheit  "F" (or "fah")  Kelvin  "K" (or "kel")  Degrees Rankine  "Rank"  Degrees Réaumur  "Reau"   Energy Units 

Joule  "J"  Erg  "e"  Thermodynamic Calorie  "c"  IT Calorie  "cal"  Electron Volt  "eV" (or "ev")  HorsepowerHour  "HPh"  WattHour  "Wh"  FootPound  "flb"  BTU  "BTU" (or "btu")   Information Units 

Bit  "bit"  Byte  "byte" 

In addition, the following text can be prepended any metric to_unit or from_unit. (E.g. the "c" prepended to the meter unit, "m" becomes "cm" to denote centimeters).
Once again, the prefixes that are colored in red were introduced in Excel 2013 and so are not available in earlier versions of Excel.
Prefix  Prefix Value  Abbreviation 

yotta  1.00E+24  "Y" 
zetta  1.00E+21  "Z" 
exa  1.00E+18  "E" 
peta  1.00E+15  "P" 
tera  1.00E+12  "T" 
giga  1.00E+09  "G" 
mega  1.00E+06  "M" 
kilo  1.00E+03  "k" 
hecto  1.00E+02  "h" 
dekao  1.00E+01  "e" (or "da") 
deci  1.00E01  "d" 
centi  1.00E02  "c" 
milli  1.00E03  "m" 
micro  1.00E06  "u" 
nano  1.00E09  "n" 
pico  1.00E12  "p" 
femto  1.00E15  "f" 
atto  1.00E18  "a" 
zepto  1.00E21  "z" 
yocto  1.00E24  "y" 

Binary Prefix  Prefix Value  Abbreviation 

yobi  2^80  "Yi" 
zebi  2^70  "Zi" 
exbi  2^60  "Ei" 
pebi  2^50  "Pi" 
tebi  2^40  "Ti" 
gibi  2^30  "Gi" 
mebi  2^20  "Mi" 
kibi  2^10  "ki" 
Convert Function Examples
The following spreadsheet shows the Excel Convert Function, used to convert between various different unit types.
Formulas:  A 

1  =CONVERT( 20.2, "m", "yd" ) 

2  =CONVERT( 20.2, "cm", "yd" ) 

3  =CONVERT( 0.2, "gal", "tsp" ) 

4  =CONVERT( 5, "gal", "l" ) 

5  =CONVERT( 0.02, "Gm", "m" ) 

6  =CONVERT( 0, "C", "F" ) 

 Results:  A 

1  22.09098863 

2  0.220909886 

3  153.6 

4  18.92705892 

5  20000000 

6  32 


For further information and examples of the Excel Convert function, see the Microsoft Office website.
Convert Function Errors
If you get an error from the Excel Convert function this is likely to be one of the following:
Common Error
#N/A    Occurs if either:  The two units supplied are not compatible (i.e. if the conversion from the from_unit to the to_unit does not make sense)
or One (or both) of the supplied units (the from_unit or the to_unit) is not a recognised abbreviated unit type.

#VALUE!    Occurs if the supplied number argument is nonnumeric. 