How to Convert Meters to Miles in Excel (3 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

Converting one dimension to another dimension seems to be a difficult task most of the time. We need to convert inches to mm, mm to feet, kg to pound, and so on. By knowing how to convert meters to miles in Excel, we can convert any values in meters to miles very easily in Excel.


How to Convert Meters to Miles in Excel: 3 Methods

We can convert various dimensions to other dimensions using Excel very easily. To show how to convert meters to miles in Excel, we have made a dataset of the Distance (in meters) of the Main Distribution Board (MDB) from the Substation of a pharmaceutical company based on the given MDB Number. The dataset is like this.

how to convert meters to miles in excelWe shall now discuss useful methods to convert meters to miles in Excel.


1. Applying CONVERT Function to Convert Meters to Miles in Excel

Applying the CONVERT function is the most common method to convert a dimension to another dimension. To convert meters to miles we have to follow the steps below.

Firstly, we have to select the cell where we need to convert from meters to miles. Here, in the picture below, we have selected the D6 cell which is in the row of MDB-1. Then to convert meters to miles, we need to apply the following formula.

=CONVERT(C6,”m”,”mi”)

Here, the C6 cell refers to the Distance of MDB 1 from the substation in meters, “m(from_unit argument) refers to meters and mi” (to_unit argument) refers to miles which is the converted dimension from meters.

how to convert meters to miles in excel

We can then convert every cell with the dimension meters to miles by using the Fill Handle. We need to drag down the reference D6 cell by holding the cursor on the right bottom corner of the cell like this.

how to convert meters to miles in excel

It will give the converted dimensions like this.

Read More: How to Convert Feet to Meters in Excel


2. Using Manual Method 

We can also use a manual method to convert inches to mm. We know that 1 meter equals 0.00062137119 miles. We can write in the D6 cell like this.

=C6*0.00062137119

Here, the C6 cell refers to the Distance of MDB-1 from the substation whose value needs to be converted to mi. The sign “*” refers to Multiplication. The number 0.00062137119 refers to 1 meter equals 0.00062137119 miles.

how to convert meters to miles in excel

We can then use Fill Handle to fill up other cells from D7 to D11 which follow the same conversion of reference cell D6.

how to convert meters to miles in excel

Read More: How to Convert Meters to Feet in Excel


3. Utilizing VBA Code to Convert Meters to Miles in Excel

Lastly, we can convert inches to mm using VBA through a simple process. To do this, we need to follow the below steps.

Step 01: Go to Visual Basic Window

  • Firstly, we need to look for the Developer tab in the Home ribbon.
  • Then, we need to select Visual Basic from the Developer tab.

how to convert meters to miles in excel

Step 02: Open a Module from Insert Button 

After finishing the first step, we need to go to the Insert button, and then we need to click on Module.

Step 03: Generate the Code and Run it 

Clicking on Module a window will appear on the screen.

Next, We need to copy and paste the following code into this window.

Sub Convert_VBA()

    Dim k As Integer

    For k = 6 To 12

     Cells(k, 4).Value = Application.WorksheetFunction.Convert(Cells(k, 3).Value, "m", "mi")

    Next k

End Sub

how to convert meters to miles in excel

Finally, we need to select Run from the top ribbon and close the window. (Also, you may press the F5 key).

how to convert meters to miles in excel

And at last, we need to go to our spreadsheet where we’ll find the conversion of meters to miles.


Things to Remember 

  • We need to use signs like commas, colon, etc. inside the CONVERT function carefully. Otherwise, we won’t get the desired converted value.
  • For the manual method, we have to always use 1 meter equals 0.00062137119 mi
  • For extended use, applying the CONVERT function is more suitable than the manual method. Because it can give relief from creating mistakes by taking 0.00062137119 as the relation between meter and mile.

Download Practice Workbook


Conclusion

How to convert dimensions in Excel is a very useful topic in Excel. In this article, we can get a clear concept of conversion between meters and miles with both the CONVERT function and the manual method. And also with the VBA code.


Related Articles


<< Go Back to Excel CONVERT Function | Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo