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