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