Excel 2007’s Hidden CONVERT Function

The CONVERT function in Excel 2007 converts a number from one measurement system to another.

For example, CONVERT can translate inches to feet.

 

 

 

 

 

 

 

 

 

 

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 (in quotation marks) for from_unit and to_unit.

Unit Names 

Inch	“in”
Foot	“ft”
Yard	“yd
Year	“yr”
Day	“day”
Hour	“hr”
Minute	“mn”
Second	“sec”
Teaspoon	“tsp”
Tablespoon	“tbs”
Fluid ounce	“oz”
Cup	“cup”
Quart	“qt”
Gallon	“gal”
Liter	“l” (or “lt”)
Celsius	“C” (or “cel”)
Fahrenheit	“F” (or “fah”)

Unit names and prefixes are case-sensitive

Advertisements