Exceljet

Quick, clean, and to the point

Excel CONVERT Function

Excel CONVERT function
Summary 

The Excel CONVERT function converts a number in one measurement system to another. For example, you can use CONVERT to convert feet into meters, pounds into kilograms, Fahrenheit to Celsius, gallons into liters, and for many other unit conversions.

Purpose 
Convert measurement units
Return value 
A number in the new measurement system
Syntax 
=CONVERT (number, from_unit, to_unit)
Arguments 
  • number - The numeric value to convert.
  • from_unit - The starting units for number.
  • to_unit - The ending units for the result.
Usage notes 

The CONVERT function converts a number in one measurement system to another. For example, you can use CONVERT to convert feet into meters, pounds into kilograms, gallons into liters, and for many other unit conversions.

The tables below show the various units that are available to the CONVERT function. In all cases, Unit can be used for either from_unit or to_unit.

Weight and mass Unit
Gram "g"
Slug "sg"
Pound mass (avoirdupois) "lbm"
U (atomic mass unit) "u"
Ounce mass (avoirdupois) "ozm"

 

Distance Unit
Meter "m"
Statute mile "mi"
Nautical mile "Nmi"
Inch "in"
Foot "ft"
Yard "yd"
Angstrom "ang"
Pica "pica"

 

Time Unit
Year "yr"
Day "day"
Hour "hr"
Minute "mn"
Second "sec"

 

Pressure Unit
Pascal "Pa" (or "p")
Atmosphere "atm" (or "at")
mm of Mercury "mmHg"

 

Force Unit
Newton "N"
Dyne "dyn" (or "dy")
Pound force "lbf"

 

Energy 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 Unit
Horsepower "HP" (or "h")
Watt "W" (or "w")

 

Magnetism Unit
Tesla "T"
Gauss "ga"

 

Temperature Unit
Degree Celsius "C" (or "cel")
Degree Fahrenheit "F" (or "fah")
Kelvin "K" (or "kel")

 

Liquid measure Unit
Teaspoon "tsp"
Tablespoon "tbs"
Fluid ounce "oz"
Cup "cup"
U.S. pint "pt" (or "us_pt")
U.K. pint "uk_pt"
Quart "qt"
Gallon "gal"
Liter "l" (or "lt")

 

The following abbreviated unit prefixes can be used with any metric unit.

Prefix Multiplier Abbreviation
exa 1E+18 "E"
peta 1E+15 "P"
tera 1E+12 "T"
giga 1E+09 "G"
mega 1E+06 "M"
kilo 1E+03 "k"
hecto 1E+02 "h"
dekao 1E+01 "e"
deci 1E-01 "d"
centi 1E-02 "c"
milli 1E-03 "m"
micro 1E-06 "u"
nano 1E-09 "n"
pico 1E-12 "p"
femto 1E-15 "f"
atto 1E-18 "a"

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.