CONVERT function

Category: Engineering
Introduced: Excel 2003

Summary

Converts a number from one measurement system to another

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.

Example

=CONVERT(1, "lbm", "kg")
=CONVERT(68, "F", "C")
=CONVERT(2.5, "ft", "sec")
=CONVERT(CONVERT(100,"ft","m"),"ft","m")

Converts 100 square feet into square meters.

9.290304



You can see how CONVERT works in Excel. Copy the following table (starting with the "6") and paste it to a blank Excel worksheet, placing the "6" in cell A1.





6


Formula

Description (Result)
=CONVERT(A1,"C","F")

Convert 6 degrees Celsius to Fahrenheit (42.8)
=CONVERT(A1,"tsp","tbs")

Convert 6 teaspoons to tablespoons (2)
=CONVERT(A1,"gal","l")

Convert 6 gallons to liters (22.71741274)
=CONVERT(A1,"mi","km")

Convert 6 miles to kilometers (9.656064)
=CONVERT(A1,"km","mi")

Convert 6 kilometers to miles (3.728227153)
=CONVERT(A1,"in","ft")

Convert 6 inches to feet (0.5)
=CONVERT(A1,"cm","in")

Convert 6 centimeters to inches (2.362204724)

Microsoft Support Page

https://support.microsoft.com/en-us/office/convert-function-d785bef1-808e-4aac-bdcd-666c810f9af2

Back to Functions