The `CONVERT` function in Excel is used to convert a number from one measurement system to another. This can include units for weight, distance, time, temperature, and more. Here’s how you can use the `CONVERT` function:
Syntax
CONVERT(number, from_unit, to_unit)
- number: The numeric value you want to convert.
- from_unit: The unit of the input number.
- to_unit: The unit to which you want to convert the number.
Steps to Use the Function
- Select a Cell: Click on the cell where you want the conversion result to appear.
- Enter the Formula: Type `=CONVERT(` into the cell.
- Specify the Arguments: Enter the numeric value you want to convert, followed by the `from_unit` and `to_unit`, separated by commas.
- Complete the Formula: Close the bracket and press `Enter`.
Examples
- Convert Meters to Feet:
If you have a value in meters in cell A1 and want to convert it to feet:
=CONVERT(A1, "m", "ft")
- Convert Pounds to Kilograms:
To convert 10 pounds to kilograms:
=CONVERT(10, "lbm", "kg")
- Convert Celsius to Fahrenheit:
Convert a value in Celsius located in cell B2 to Fahrenheit:
=CONVERT(B2, "C", "F")
Unit Codes
Excel uses specific unit codes for the `from_unit` and `to_unit` arguments. Some common ones include:
- Distance:
- Meter: `”m”`
- Kilometer: `”km”`
- Mile: `”mi”`
- Inch: `”in”`
- Foot: `”ft”`
- Weight:
- Gram: `”g”`
- Kilogram: `”kg”`
- Pound: `”lbm”`
- Ounce: `”ozm”`
- Time:
- Second: `”sec”`
- Minute: `”min”`
- Hour: `”hr”`
- Day: `”day”`
- Temperature:
- Celsius: `”C”`
- Fahrenheit: `”F”`
- Kelvin: `”K”`
- Volume:
- Liter: `”l”`
- Gallon: `”gal”`
This function is very handy for converting units directly in Excel without having to perform manual calculations. For a comprehensive list of all unit codes available in Excel, you can refer to the Microsoft Excel documentation on the `CONVERT` function.
Unlock Your Potential
Excel
Access
Power BI
