Very often we need to convert units in our daily life. Well, Excel provides a built-in function that can help us convert units quite easily. We can also use Microsoft Excel as a general-purpose calculator to convert units one from another. Today, in this article, I’m going to show you 2 quick ways to convert inches to meters in Excel with ease.
How to Convert Inches to Meters in Excel: 2 Quick Ways
I’m going to use the following Employee Height Records as a dataset. In the dataset, against each of the employee names, there are their corresponding heights in inches. Then I took another column called Height (Meters), where I will be calculating the height in inches to meters. So, let’s get started.
1. Using CONVERT Function to Convert Inches to Meters
Excel has a built-in function called CONVERT that enables us to convert different types of units. Here, I will use the CONVERT function to show you how to convert inches to meters.
The convert function has the following syntax:
=CONVERT(number,from_unit,to_unit)Now, follow the steps below to convert inches to meters.
❶ At first, insert the following formula in cell D5.
=CONVERT(C5,"in","m")❷ Then press the ENTER button.
Formula Breakdown
- C5 is the cell address having the heights in inches.
- “in” refers to the heights in inches. This one is the from_unit argument in the CONVERT function syntax.
- “M” refers to the heights in meters. This one is the to_unit argument in the CONVERT
- So, the CONVERT function changes the unit of the value in cell C5 from inches to meters.
❸ Now, drag down the Fill Handle to copy down the formula all the way.
Now, you will see that the heights in inches have converted into heights in meters.
Here, if you look at the result of the CONVERT function, you will notice that it returns up to 6 decimal places after the decimal point.
However, if you don’t want this many decimal places in the case of fraction numbers, you can trim them by using the ROUND function. I have covered this section in the next method.
Read More: How to Convert Inches to Cm in Excel
2. Manual Method with ROUND Function to Convert Inches to Meters
In this section, I will show you converting inches to meters using the general division and the ROUND function.
We know that 1 meter equals 39.3701 inches. So, to convert inches to meters, we need to divide the heights in inches by 39.701.
The result of the division might have decimal places up to 15 digits. Having this many decimal places is impractical to use. That’s why I will use the ROUND function to round off the result of the conversion.
Now, follow the steps below to convert inches to meters.
❶ At first, insert the following formula in cell D5.
=ROUND(C5/39.3701,2)❷ After that press ENTER.
Formula Breakdown
- C5 is the cell address that contains heights in inches.
- C5/39.3701: As 1 meter equals 3701 inches, dividing total heights in inches by 39.3701 will produce heights in meters.
- 2 refers that the ROUND function will round off the result of the division to 2 decimal places after the decimal point.
❸ After that, drag the Fill Handle icon to copy down the formula.
Finally, you will see in the Height (Meters) columns that all the heights in inches have been converted into heights in meters.
Read More: How to Convert Feet to Inches in Excel
Things to Remember
- The CONVERT function returns decimal places up to 6 digits after the decimal point.
- Excel supports a precision of up to 15 digits in the case of decimal fraction numbers.
Practice Section
You will get an Excel sheet like the following screenshot, at the end of the provided Excel file where you can practice all the methods discussed in this article.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
Conclusion
To sum up, we have discussed 2 ways to convert inches to meters n in Excel. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries ASAP.
Related Articles
- How to Convert inch to mm in Excel
- How to Convert Inches to Feet in Excel
- How to Convert Inches to Square Feet in Excel
- How to Convert Inches to Feet and Inches in Excel
- How to Convert Feet and Inches to Decimal in Excel
- How to Convert Decimal Feet to Feet and Inches in Excel
- How to Convert Millimeters (mm) to Inches (in) in Excel
- How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel
