MS Excel: How to use the CONVERT Function (WS)

This Excel tutorial explains how to use the Excel CONVERT function with syntax and examples.

Description

The Microsoft Excel CONVERT function will convert a number from one measurement unit to another measurement unit.

The CONVERT function is a built-in function in Excel that is categorized as an Engineering Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the CONVERT function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the CONVERT function in Microsoft Excel is:

CONVERT( number, from_units, to_units )

Parameters or Arguments

number

The value to be converted (number is written in from_units).

from_units

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

to_units

The units of measure that you wish to convert number to.

Returns

The CONVERT function returns a numeric value.

Applies To

• Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007

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 Excel spreadsheet above, the following 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