The Excel CONVERT Function

Basic Description

The Excel CONVERT function converts a number from one unit type (eg. Yards) to another unit type (eg. Meters). The function is new to Excel 2007, so is not available in earlier versions of MS Excel.

The format of the function is :

CONVERT( number, from_unit, to_unit )

Where the arguments are as follows :

number - The number to be converted
from_unit - A text string, denoting the current unit for the original number
from_unit - A text string, denoting the unit that you want to convert the original number to

The from_unit and to_unit arguments to the Excel Convert function must make sense - ie. they may not be from different measurement types (eg. temperature & distance). If you attempt to convert between two different measurement types, Excel will return the #N/A error.

The tables below show all the different measurement types that the Excel Convert Function can work with, and show the text abbreviations that must be supplied to the function to denote each unit type. Note that the text abbreviations for the unit types are case sensitive.

Distance Units
Meter "m"
Statute Mile "mi"
Nautical Mile "Nmi"
Inch "in"
Foot "ft"
Yard "yd"
Angstrom "ang"
Pica "Pica"
Liquid Units
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")
Temperature Units
Degree Celsius "C" (or "cel")
Degree Fahrenheit "F" (or "fah")
Kelvin "K" (or "kel")
Power Units
Horsepower "HP" (or "h")
Watt "W" (or "w")
Magnetism Units
Tesla "T"
Gauss "ga"
Time Units
Year "yr"
Day "day"
Hour "hr"
Minute "mn"
Second "sec"
Weight & Mass Units
Gram "g"
Slug "sg"
Pound Mass "lbm"
U (Atomic Mass Unit) "u"
Ounce Mass "ozm"
Force Units
Newton "N"
Dyne "dyn" (or "dy")
Pound Force "lbf"
Pressure Units
Pascal "Pa" (or "p")
Atmosphere "atm" (or "at")
mm of Mercury "mmHg"
Energy Units
Joule "J"
Erg "e"
Thermodynamic Calorie "c"
IT Calorie "cal"
Electron Volt "eV" (or "ev")
Horsepower-Hour "HPh"
Watt-Hour "Wh"
Foot-Pound "flb"
BTU "BTU" (or "btu")

In addition, the following text can be prepended any metric to_unit or from_unit
(eg. the "c" prepended to the meter unit, "m" becomes "cm" to denote centimeters) :

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

Convert Function Examples

The following spreadsheets show some examples of use of the Excel Convert Function. The spreadsheet on the left shows the format of the function and the spreadsheet on the right shows the results :

Example of use of the Excel Convert Function
Excel Convert Function Results
Return to the Excel Engineering Functions page

Return to the List of All Excel Built-In Functions page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013