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.

convert 

 

 

 

 

 

 

 

 

 

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s