Unit conversion is a common operation that we conduct daily. Most of the time, converting one dimension to another appears to be a challenging undertaking. For many people in several disciplines, converting units of measurement is an unavoidable evil. We may need to convert millimeters (mm) to feet (ft) and inches (in) in a variety of scenarios. We can always utilize Excel to complete this sort of assignment. In this article, we will demonstrate some effective ways to convert millimeters (mm) to feet (ft) and inches (in) in Excel.
How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel: 4 Ways
Excel makes it simple to convert some measurements to other dimensions. To convert millimeters (mm) to feet (ft) and inches (in), we are going to use the following dataset for a survey. The dataset contains some person’s name and their height in mm. Now, we want to convert the height to feet and inches. So, let’s get started.
1. Insert Excel CONVERT Function to Convert Millimeters to Feet and Inches
The CONVERT function in Excel is a constructed tool that aids with unit conversions. The most frequent approach for converting one dimension to another is to use the CONVERT function. This converts a number between different measuring systems. To convert millimeters (mm) to feet (ft), and inches (in) using the CONVERT function, follow the steps below.
📌 STEPS:
- Firstly, we will get the ft. For this, select the cell where you want to put the formula of the CONVERT function. So, we select cell D5.
- Secondly, put the formula into that selected cell.
=CONVERT(C5,"mm","ft")&"' "- Thirdly, press Enter.
- Now, drag the Fill Handle down to duplicate the formula over the range. Or, to AutoFill the range, double-click on the plus (+) symbol.
- Finally, you can see the height in millimeters is now converted into height in feet.
- Further, to convert the mm to in, choose the cell where you wish to put the CONVERT function’s formula. As a result, we chose cell E5.
- Then, type the formula into the cell you have chosen.
=CONVERT(C5,"mm","in")&""""- Press Enter to complete the step.
- Furthermore, drag the Fill Handle downward to apply the formula across the range. Or, double-click on the plus (+) sign to AutoFill the range.
- Finally, this will convert all the person’s height from mm to in.
Read More: How to Convert inch to mm in Excel
2. Combine INT and ROUND Functions to Turn Millimeters (mm) into Feet (ft) and Inches (in)
The INT function in Excel will return the integer component of a decimal value by decimal digits to the integers. The ROUND function produces a value that has been rounded to a specified number of digits. This just rounds the digits to the right or left. But those functions have much use. We can combine both functions to convert Millimeters (mm) to Feet (ft), and Inches (in) in Excel. Let’s follow the steps for this.
📌 STEPS:
- We will start with the feet. To begin with, choose the cell (D5) where you want to insert the INT and ROUND functions’ formula.
- Secondly, type the formula below into the selected cell.
=INT(ROUND(C5*0.03937,0)/12)&"' "- Further, press the Enter key to finish the procedure.
- Furthermore, to copy the formula over the range, drag the Fill Handle down or double-click on the plus (+) icon.
- Lastly, you will be able to see the conversion of the height.
- Further, to get the inches from millimeters. Select cell E5.
- Then, in that selected cell, type in the formula below.
=INT(C5/25.4)&""""- Hit the Enter key to complete the process.
- The result will now be displayed in the selected cell, along with the formula in the formula bar.
- Furthermore, drag the Fill Handle down to duplicate the formula across the range. Alternatively, to AutoFill the range, double-click the plus (+) symbol.
- Finally, you will indeed be able to view the measurement conversion.
Read More: How to Convert Units in Excel
3. Use Arithmetic Formula to Convert Millimeters to Feet and Inches
By manually entering the arithmetic formula, we may obtain the dimensions in Inches (in) and Feet (ft) from Millimeters (mm).
1 mm = 0.0032808 ft
1 mm = 0.03937 in
The distance d in inches (in) is calculated by dividing the significant distance in millimeters (mm) by 25.4:
Inches = Millimeters / 25.4
The base value of the given distance in inches (in) divided by 12 equals the significant distance in feet (ft):
Feet = Inches / 12
or,
Feet = Millimeters / 25.4 / 12
Now, simply follow the procedures outlined below.
📌 STEPS:
- Similarly, as in the previous method, select cell D5 and substitute the formula to get the inches from millimeters.
- Then, type the formula into the cell that we have selected.
=C5/25.4- Next, press Enter.
- After that, drag the Fill Handle to the bottom to reproduce the formula throughout the whole range. Double-click the plus (+) sign to AutoFill the range.
- Finally, you can see that the millimeters are converted into inches in column D.
- Further, we will find the feet from the millimeters. For this, select cell E5.
- Now, insert the following formula into that cell.
=D5/12- Hit the Enter button from the keyboard.
- Alternatively, you can use this formula to convert the millimeters to feet.
=C5/25.4/12- Press Enter.
- Further, drag the Fill Handle downward to apply the formula across the range. Or, double-click on the plus (+) sign to AutoFill the range.
- Finally, you will be able to see the conversion of measurements.
Read More: How to Convert Inches to Square Feet in Excel
4. Apply Excel VBA to Convert Millimeters (mm) to Feet (ft) and Inches (in)
With Excel VBA, users can easily use the code that acts as Excel functions. To use the VBA code to convert mm to feet and inches, let’s follow the procedure.
📌 STEPS:
- Firstly, go to the Developer tab from the ribbon.
- Secondly, from the Code category, click on Visual Basic to open the Visual Basic Editor. Or press Alt + F11 to open the Visual Basic Editor.
- Instead of doing this, you can just right-click on your worksheet and go to View Code. This will also take you to Visual Basic Editor.
- This will appear in the Visual Basic Editor where we write our codes to create a table from range.
- Thirdly, click on Module from the Insert drop-down menu bar.
- This will create a Module in your workbook.
- And, copy and paste the VBA code shown below.
VBA Code:
Sub mm_to_ft_in()
Dim a As Integer
For a = 5 To 10
Cells(a, 4).Value = Application.WorksheetFunction.Convert(Cells(a, 3).Value, "mm", "ft")
Next a
For b = 5 To 10
Cells(b, 5).Value = Application.WorksheetFunction.Convert(Cells(b, 3).Value, "mm", "in")
Next b
End Sub- After that, run the code by clicking on the RubSub button or pressing the keyboard shortcut F5.
You don’t need to change the code. All you can do is just change the range as per your requirements.
- And, finally, following the steps will convert the mm to feet and inches.
VBA Code Explanation
Sub mm_to_ft_in()Sub is a part of code that is used to handle the work in the code but will not return any value. It is also known as subprocedure. So we name our procedure mm_to_ft_in().
Dim a As IntegerThe DIM statement in VBA refers to ‘declare,’ and it must be used to declare a variable. So, we declare the integer value as a.
For a = 5 To 10
Cells(a, 4).Value = Application.WorksheetFunction.Convert(Cells(a, 3).Value, "mm", "ft")
Next aThe For Next Loop begins with row 5, we chose 5 as the beginning value. The Cells property is then used to write values. Finally, the VBA Convert function converts millimeters to feet, and we have used the cell’s property to run over our cell values again.
For b = 5 To 10
Cells(b, 5).Value = Application.WorksheetFunction.Convert(Cells(b, 3).Value, "mm", "in")
Next bHere, row 5 is the start of the For Next Loop, and we choose 5 as the starting value. The values are then written using the Cells property. Then, we used the VBA Convert function to convert millimeters to inches, and we ran through our cell values again with the cell’s property.
End SubThis will end the procedure.
Read More: How to Convert Inches to Feet and Inches in Excel
Things to Remember
- Keep in mind that the case of the unit codes or names matters. You will receive a #N/A! error if you use “MM”, “FT”, and “IN.”
- Excel will display a list of available units as you type the formula. Even though “mm” is not on that list, it will suffice.
- You will get the #N/A! error if you make a mistake while inputting the formula, such as not following the correct format.
Download Practice Workbook
Conclusion
The above methods will assist you to Convert mm to Feet and Inches in Excel. Hope this will help you! Please let us know in the comment section if you have any questions, suggestions, or feedback.
Related Articles
- How to Convert Inches to Cm in Excel
- How to Convert Inches to Meters in Excel
- How to Convert Inches to Feet in Excel
- How to Convert Feet to Inches in Excel
- How to Convert Feet and Inches to Decimal in Excel
- How to Convert Decimal Feet to Feet and Inches in Excel
<< Go Back to Excel CONVERT Function | Excel Functions | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
Hi, i tried your formula but my result is a number with more then 10 decimals. i tried to change format in number and cut decimals but nothing happens, how can i do?
Hello MATTEO
Thanks for visiting our blog and sharing your problem. Excel’s internal precision for numerical calculations can sometimes lead to unexpected results, especially when dealing with tiny or huge numbers.
To overcome your situation, you can combine the ROUND and CONVERT functions.
“mm” to “ft”:
“mm” to “in”:
Hopefully, the formula will help you overcome your situation; good luck.
Regards
Lutfor Rahman Shimanto
ExcelDemy