====== 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|