CONVERT Function In Excel

Excel CONVERT function defines that it can convert the numbers from one measurement system to another measurement system. So, for example, if we have numbers in meters, we can convert them to feet. If we have numbers in pounds, we can convert them to KG. If we have numbers in feet, we can convert them to centimeters.

Consider the below table showing product A. Assume that we have to convert the weight from kg to pounds.

Now, using convert function in Excel, we can find the result as shown in the below image.

Likewise, we can use convert function in Excel.

In this article, let us learn how to use convert function in Excel.

• CONVERT function in Excel is an inbuilt function used to convert data into other measurement units.
• This function was introduced from Excel 2013 onwards. All the arguments in the formula are mandatory.
• Remember, the commonly used measurements are “weight,” “distance,” “time,” and “travel.”
• We need to ensure what measurement key we are using in the formula to avoid errors.
• Meanwhile, note that the number argument should always be a numerical value or numerical value cell reference; otherwise, we can get #NUM! Error.

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. Let us learn how to use convert function in Excel with detailed examples.

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.

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.

Example #3

Below is the list of products and their weight in kilograms. We need to convert this weight into pounds using Excel.

• 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.

Likewise, we can use convert function in Excel.

• Introduced in 2013, this convert function helps users convert value into other measurements.
• The syntax is =CONVERT(number,from_unit,to_unit) where all the arguments are mandatory.

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 CSV
• How to Convert Columns to Rows in Excel?
• Excel Break-Even Point Examples
• Group Excel Data
• Share an Excel Workbook