This article describes the formula syntax and usage of the CONVERT function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
Description
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)
The CONVERT function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
 Number Required. The value in from_units to convert.
 From_unit Required. The units for number.
 To_unit Required. 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" 
Distance 
From_unit or to_unit 
Meter 
"m" 
Statute mile 
"mi" 
Nautical mile 
"Nmi" 
Inch 
"in" 
Foot 
"ft" 
Yard 
"yd" 
Angstrom 
"ang" 
Pica 
"pica" 
Time 
From_unit or to_unit 
Year 
"yr" 
Day 
"day" 
Hour 
"hr" 
Minute 
"mn" 
Second 
"sec" 
Pressure 
From_unit or to_unit 
Pascal 
"Pa" (or "p") 
Atmosphere 
"atm" (or "at") 
mm of Mercury 
"mmHg" 
Force 
From_unit or to_unit 
Newton 
"N" 
Dyne 
"dyn" (or "dy") 
Pound force 
"lbf" 
Energy 
From_unit or to_unit 
Joule 
"J" 
Erg 
"e" 
Thermodynamic calorie 
"c" 
IT calorie 
"cal" 
Electron volt 
"eV" (or "ev") 
Horsepowerhour 
"HPh" (or "hh") 
Watthour 
"Wh" (or "wh") 
Footpound 
"flb" 
BTU 
"BTU" (or "btu") 
Power 
From_unit or to_unit 
Horsepower 
"HP" (or "h") 
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") 
Liquid measure 
From_unit or to_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 prepended to any metric from_unit or to_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 
1E01 
"d" 
centi 
1E02 
"c" 
milli 
1E03 
"m" 
micro 
1E06 
"u" 
nano 
1E09 
"n" 
pico 
1E12 
"p" 
femto 
1E15 
"f" 
atto 
1E18 
"a" 
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 an abbreviated unit 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 casesensitive.
Example
The example may be easier to understand if you copy it to a blank worksheet.
How do I copy an example?
 Select the example in this article. If you are copying the example in Excel Online, copy and paste one cell at a time.
Important: Do not select the row or column headers.
Selecting an example from Help
 Press CTRL+C.
 Create a blank workbook or worksheet.
 In the worksheet, select cell A1, and press CTRL+V. If you are working in Excel Online, repeat copying and pasting for each cell in the example.
Important: For the example to work properly, you must paste it into cell A1 of the worksheet.
 To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
After you copy the example to a blank worksheet, you can adapt it to suit your needs.

A 
B 
Formula 
Description (Result) 
=CONVERT(1.0, "lbm", "kg") 
Converts 1 pound mass to kilograms (0.453592) 
=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). 
