How to Convert Inches to Meters in Excel (2 Quick Ways)

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.

Download Practice Workbook

You can download the Excel file from the following link and practice along with it.

2 Ways to Convert Inches to Meters in Excel

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:

Now, follow the steps below to convert inches to meters.

❶ At first, insert the following formula in cell D5.

❷ Then press the ENTER button.

❸ 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 the 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 Quick Ways)

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.

❷ After that press ENTER.

❸ 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 Meters in Excel (4 Simple Methods)

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.

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. And please visit our website Exceldemy to explore more.

Related Articles

• How to Convert Inches to Square Feet in Excel (2 Easy Methods)
• Converting CM to Inches in Excel (2 Simple Methods)
• How to Convert CM to Feet and Inches in Excel (3 Effective Ways)
• Millimeter(mm) to Square Meter Formula in Excel (2 Easy Methods)
• Convert Meters to Feet in Excel (4 Useful Methods)
• How to Convert Feet to Inches in Excel (4 Quick Methods)
• Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)