Convert Function in Excel

Excel CONVERT Function

Excel CONVERT Function as the word itself says it will convert the number from one measurement system to another measurement system. For example, if we have numbers in meters we can convert them to feet if we have numbers in pounds we can convert to KG if we have numbers in feet we can convert to centimeters and so on.

Below is the syntax of the CONVERT function.

Convert Function in Excel
  • Number: The value that we are trying to convert.
  • From Unit: The current measurement unit of the Number. This argument has plenty of measurement codes; we will see this in a while.
  • To Unit: For which measurement unit, we need to convert the Number.

Measurement has different categories, and each category has different measurement units. Below is the detailed list of the same.

Time Units

Time Units

Speed Units

Speed Units

Force Units

Force Units

Power Units

Power Units

Temperature Units

Temprature Units

Distance Units

Distance Units

Energy Units

Energy Units

Pressure Units

Pressure Units

Weight Units

Weight Units

Above I had given some of the commonly used measurement units. You can go through the function parameters for other measurement units.

How to Convert Units in Excel?

You can download this Convert Function Excel Template here – Convert Function Excel Template

Example #1

Convert Function - Example 1.1

Copy the above data to excel first. We have fruit weight in “Kilo Grams,” and we need to convert it to “Pounds.”

Below is the list of fruits and their weight in kilograms. Convert this weight in pounds using excel.

  1. Open CONVERT function

    Open the function in cell C2.

    Convert Function - Example 1.2

  2. Select the number we are trying to convert.

    The number that we are trying to convert is B2 cell value, so select the B2 cell as the reference cell.

    Convert Function - Example 1.3

  3. Specify Current Unit

    The second argument is “From Unit” before we convert to some other units, we need to specify what the current unit is. So the current unit is “Kilo Gram,” and from the list, choose “G” as the current unit.

    Convert Function - Example 1.4

  4. Specify the Unit to be converted into.

    The next argument is “To Unit,” so we are trying to convert to “Pounds,” so choose “lbm.”

    Convert Function - Example 1.5

  5. Once the arguments are supplied, we need to multiply the value by 1000 to get the result in pounds. So close the bracket and multiply excelMultiply ExcelThere is no specific multiply function in Excel. Still, you can perform the multiply operation using the asterisk symbol (*), PRODUCT function, and SUMPRODUCT function to get the multiplication. You can perform a specific set of calculations in a cell, column, or row using this.read more it by 1000.



    Convert Function - Example 1.6

  6. Hit the enter key to get the result.

    Convert Function - Example 1.7

  7. Now drag the formula to other cells.

    Convert Function - Output 1

Example #2

Below is the height of students in a classroom, and their height is in “Meters,” and we need to convert it to “Inches” using the convert function.

Convert Function - Example 2.1

The meter measurement unit is “m,” and the inches measurement unit is “in.” Apply the same to get the result.

Open the CONVERT function in cell C2, and select cell B2 as this is the number we are trying to convert.

Convert Function - Example 2.2

The second argument is “From Unit” here; we need to specify what the current unit is. So the current unit is “meter” and from the list choose “m” as the current unit.

Convert Function - Example 2.3

The next argument is “To Unit,” we are trying to convert to “Inches,” so choose “in.”

Convert Function - Example 2.4

Now close the bracket and press enter to get the height in inches.

Convert Function - Example 2.5

Drag the formula to below cells.

Convert Function - Output 2

Things to Remember

  • CONVERT function has more measurement units from Excel 2013 onwards.
  • Commonly used measurements are “Weight, Distance, Time, and Travel.”
  • You need to sure of what measurement key you are using.
  • The number argument should always be a numerical value or numerical value cell reference other-wise, we will get #NUM! Error.

This has been a guide to Convert Function in Excel. Here we discuss how to use the convert function to convert the number from one measurement to another. You can learn more from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>