Excel CONVERT Function

Below is the syntax of the CONVERT function.

  • 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: We need to convert the number for the measurement unit.

The measurement has different categories. Each category has other measurement units. Below is the detailed list of the same.

Time Units

Speed Units

Force Units

Power Units

Temperature Units

Distance Units

Energy Units

Pressure Units

Weight Units

Above, we have given some of the commonly used measurement units. In addition, you may look through the function parameters for other measurement units.

How to Convert Units in Excel?

Example #1

We must copy the above data to Excel first. For example, we have fruit weight in “KiloGrams,” and we need to convert it to “Pounds.”

Example #2

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

  • Open CONVERT function We must first open the function in cell C2. Please select the number we are trying to convert. We are trying to convert the number to its B2 cell value. So we must select the B2 cell as the reference cell. Specify Current Unit The second argument is “From Unit” before converting to some other units. First, we need to specify the current unit. So, the current unit is “KiloGram.”Next, we need to choose “G” as the current unit from the list. Specify the Unit to be converted into. The next argument is “To Unit.” So, we are trying to convert to “Pounds,” so choose “LBM.” Once the arguments are supplied, we need to multiply the value by 1,000 to get the result in pounds. So, close the bracket and multiply Excel by 1,000. Then, press the “Enter” key to get the result. Now, drag the formula to other cells.

We must first open the function in cell C2.

We are trying to convert the number to its B2 cell value. So we must select the B2 cell as the reference cell.

The second argument is “From Unit” before converting to some other units. First, we need to specify the current unit. So, the current unit is “KiloGram.”Next, we need to choose “G” as the current unit from the list.

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

The meter measurement unit is “m,” and the inches measurement unit is “in.” Therefore, we must apply the same to get the result.

Then, we need to open the CONVERT function in cell C2 and select cell B2 as it is the number we are trying to convert.

The second argument is “From Unit” here. First, we need to specify what the current unit is. So, the current unit is a “Meters.” Then, choose “m” from the list as the current unit.

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

We need to close the bracket and press the “Enter” to get the height in inches.

Then, drag the formula to the below cells.

Things to Remember

  • The CONVERT function has more measurement units from Excel 2013 onwards.The commonly used measurements are “weight,” “distance,” “time,” and “travel.”We need to ensure what measurement key we are using.The number argument should always be a numerical value or numerical value cell reference; otherwise, we can get #NUM! Error.

This article is a guide to Convert Function in Excel. Here, we discuss using the convert function to convert the number from one measurement to another. You can learn more from the following Excel articles: –

  • Convert Excel to CSVHow to Convert Columns to Rows in Excel?Excel Break-Even Point ExamplesGroup Excel DataShare an Excel Workbook