CONVERT

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.

If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using Add-Ins on the Tools menu.

Syntax

CONVERT(number,from_unit,to_unit)

Number is the value in from_units to convert.

From_unit is the units for number.

To_unit is the units for the result. CONVERT accepts the following text values 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 (1/72 in.)	"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"
Atmosphere	"atm"
mm of Mercury	"mmHg"

Force	From_unit or to_unit

Newton	"N"
Dyne	"dyn"
Pound force	"lbf"

Energy	From_unit or to_unit

Joule	"J"
Erg	"e"
Thermodynamic calorie	"c"
IT calorie	"cal"
Electron volt	"eV"
Horsepower-hour	"HPh"
Watt-hour	"Wh"
Foot-pound	"flb"
BTU	"BTU"

Power	From_unit or to_unit

Horsepower	"HP"
Watt	"W"

Magnetism	From_unit or to_unit

Tesla	"T"
Gauss	"ga"

Temperature	From_unit or to_unit

Degree Celsius	"C"
Degree Fahrenheit	"F"
Degree Kelvin	"K"

Liquid measure	From_unit or to_unit

Teaspoon	"tsp"
Tablespoon	"tbs"
Fluid ounce	"oz"
Cup	"cup"
Pint	"pt"
Quart	"qt"
Gallon	"gal"
Liter	"l"

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	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"

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 case-sensitive.

Examples

CONVERT(1.0, "lbm", "kg") equals 0.453592

CONVERT(68, "F", "C") equals 20

CONVERT(2.5, "ft", "sec") equals #N/A