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
Examples
CONVERT(1.0, "lbm", "kg")
equals 0.453592
CONVERT(68, "F", "C")
equals 20
CONVERT(2.5, "ft", "sec")
equals #N/A