Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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 =====

<code>
CONVERT(number,from_unit,to_unit)
</code>

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|