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.
- 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.
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?
Below is the list of fruits and their weight in kilograms. Convert this weight in pounds using excel.
Copy the above data to excel first. We have fruit weight in “Kilo Grams” and we need to convert it to “Pounds”.
Step 1: Open CONVERT function
Open the function in cell C2.
Step 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.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
Step 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.
Step 4: Specify 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 1000 to get the result in pounds. So close the bracket and multiply excel it by 1000.
Step 5: Hit enter key to get the result.
Now drag the formula to other cells.
Below is the height of students in a classroom and their height is in “Meters” and we need to convert it to “Inches” using convert function.
The meter measurement unit is “m” and the inches measurement unit is “in”. Apply the same to get the result.
Open CONVERT function in cell C2 and select B2 cell as this is the number we are trying to convert.
The second argument of 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.
The next argument is “To Unit” we are trying to convert to “Inches” so choose “in”.
Now close the bracket and press enter to get the height in inches.
Drag the formula to below cells.
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.
- 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 convert function to convert the number from one measurement to another. You can learn more from the following articles –