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.

Convert Inches to Meters in Excel


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.

Using CONVERT Function to Convert 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 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.

=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 equals3701 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.

Manual Method with ROUND Function to Convert Inches to Meters

❸ 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

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo