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.
Syntax
CONVERT(<=
b>number,from_unit,to_unit)
Number i=
s the
value in from_units to convert.
From_unit is=
the
units for number.
To_unit i=
s the
units for the result. CONVERT accepts the following text values (in quotati=
on
marks) for from_unit and to_unit.
Weight and mass 
From_unit or to_unit 
Gram 
"g" 
Slug 
"sg" 
Pound mass (avoirdupo=
is) 
"lbm" 
U (atomic mass unit)<= o:p> 
"u" 
Ounce mass (avoirdupo=
is) 
"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" (or
"p") 
Atmosphere 
"atm" (or
"at") 
mm of Mercury 
"mmHg" 
Force 
From_unit or to_unit 
Newton 
"N" 
Dyne 
"dyn" (or
"dy") 
Pound force 
"lbf" 
Energy 
From_unit or to_unit 
Joule 
"J" 
Erg 
"e" 
Thermodynamic calorie=

"c" 
IT calorie 
"cal" 
Electron volt 
"eV" (or
"ev") 
Horsepowerhour 
"HPh" (or
"hh") 
Watthour 
"Wh" (or
"wh") 
Footpound 
"flb" 
BTU 
"BTU" (or
"btu") 
Power 
From_unit or to_unit 
Horsepower 
"HP" (or
"h") 
Watt 
"W" (or
"w") 
Magnetism 
From_unit or to_unit 
Tesla 
"T" 
Gauss 
"ga" 
Temperature 
From_unit or to_unit 
Degree Celsius 
"C" (or
"cel") 
Degree Fahrenheit 
"F" (or
"fah") 
Kelvin 
"K" (or
"kel") 
Liquid measure 
From_unit or to_unit 
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") 
The following abbreviated u=
nit 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 
1E01 
"d" 
centi 
1E02 
"c" 
milli 
1E03 
"m" 
micro 
1E06 
"u" 
nano 
1E09 
"n" 
pico 
1E12 
"p" 
femto 
1E15 
"f" 
atto 
1E18 
"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.
Un=
it
names and prefixes are casesensitive.
Example
The example may be easier to
understand if you copy it to a blank worksheet.
1.&n=
bsp;
Create a blank workbook or worksheet.
2.&n=
bsp;
Select the example in the Help topic.
Note Do not select t=
he row
or column headers.
Se=
lecting
an example from Help
3.&n=
bsp;
Press CTRL+C.
4.&n=
bsp;
In the worksheet, select cell A1, and press CTRL+V.
5.&n=
bsp;
To switch between viewing the results and viewing the formul=
as
that return the results, press CTRL+` (grave accent), or on the Formulas=
tab, in the Formula Auditing group, click the Show Formulas
button.

