This Excel tutorial explains how to use the Excel CONVERT function with syntax and examples.
from_units is the original units of measure for number. It can be one of the following values:
to_units is the units of measure that you wish to convert number to.
Based on the spreadsheet above, the following Excel CONVERT examples would return:
Description
The Microsoft Excel CONVERT function will convert a number from one measurement unit to another measurement unit.Syntax
The syntax for the Microsoft Excel CONVERT function is:CONVERT( number, from_units, to_units )
Parameters or Arguments
number is the value to be converted (number is written in from_units).from_units is the original units of measure for number. It can be one of the following values:
| Value | Measurement Unit | Measurement Type |
|---|---|---|
| "m" | Meter | Length/Distance |
| "mi" | Mile | Length/Distance |
| "Nmi" | Nautical mile | Length/Distance |
| "in" | Inch | Length/Distance |
| "ft" | Foot | Length/Distance |
| "yd" | Yard | Length/Distance |
| "ang" | Angstrom | Length/Distance |
| "pica" | Pica | Length/Distance |
| "g" | Gram | Weight/Mass |
| "sg" | Slug | Weight/Mass |
| "lbm" | Pound | Weight/Mass |
| "u" | Atomic unit | Weight/Mass |
| "ozm" | Ounce | Weight/Mass |
| "yr" | Year | Time |
| "day" | Day | Time |
| "hr" | Hour | Time |
| "mn" | Minute | Time |
| "sec" | Second | Time |
| "C" or "cel" | Celsius | Temperature |
| "F" or "fah" | Fahrenheit | Temperature |
| "K" or "kel" | Kelvin | Temperature |
| "tsp" | Teaspoon | Liquid Volume |
| "tbs" | Tablespoon | Liquid Volume |
| "oz" | Fluid ounce | Liquid Volume |
| "cup" | Cup | Liquid Volume |
| "pt" or "us_pt" | US pint | Liquid Volume |
| "uk_pt" | UK pint | Liquid Volume |
| "qt" | Quart | Liquid Volume |
| "gal" | Gallon | Liquid Volume |
| "l" or "lt" | Liter | Liquid Volume |
| "N" | Newton | Force |
| "dyn" or "dy" | Dyne | Force |
| "lbf" | Pound Force | Force |
| "Pa" or "p" | Pascal | Pressure |
| "atm" | Atmosphere | Pressure |
| "mmHg" | mm of Mercury | Pressure |
| "HP" or "h" | Horsepower | Power |
| "W" or "w" | Watt | Power |
| "J" | Joule | Energy |
| "e" | Erg | Energy |
| "c" | Thermodynamic calorie | Energy |
| "cal" | IT calorie | Energy |
| "eV" or "ev" | Electron volt | Energy |
| "HPh" or "hh" | Horsepower-hour | Energy |
| "Wh" or "wh" | Watt-hour | Energy |
| "flb" | Foot-pound | Energy |
| "BTU" or "btu" | BTU | Energy |
| "T" | Tesla | Magnetism |
| "ga" | Gauss | Magnetism |
Applies To
The CONVERT function can be used in the following versions of Microsoft Excel:- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007
Type of Excel Function
The CONVERT function can be used in Microsoft Excel as the following type of function:- Worksheet function (WS)
Example (as Worksheet Function)
Let's look at some Excel CONVERT function examples and explore how to use the CONVERT function as a worksheet function in Microsoft Excel:Based on the spreadsheet above, the following Excel CONVERT examples would return:
=CONVERT(A1,"in","ft") Result: 2 =CONVERT(A2,"F","C") Result: -15 =CONVERT(A3,"mn","sec") Result: 120 =CONVERT(1,"mn","sec") Result: 60
