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

Examples

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

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

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