# How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel – 4 Methods

The dataset contains people’s names and their height in mm. To convert the height to feet and inches:

### Method 1 – Using the Excel CONVERT Function to Convert Millimeters to Feet and Inches

STEPS:

• To convert values to ft: Select D5.
• Enter the formula.
`=CONVERT(C5,"mm","ft")&"'  "`
• Press Enter.

• Drag down the Fill Handle to see the result in the rest of the cells.

The height in millimeters is converted into feet.

`=CONVERT(C5,"mm","in")&""""`
• Press Enter.

• Drag down the Fill Handle to see the result in the rest of the cells. Or, double-click the plus (+) sign to AutoFill the range.

mm are converted to in.

Read More: How to Convert inch to mm in Excel

### Method 2 – Combine the INT and ROUND Functions to Turn Millimeters (mm) into Feet (ft) and Inches (in)

STEPS:

• To convert values to ft: Select D5.
• Enter the formula.
`=INT(ROUND(C5*0.03937,0)/12)&"' "`
• Press Enter.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

`=INT(C5/25.4)&""""`
• Press Enter.

This is the output.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the final output.

Read More: How to Convert Units in Excel

### Method 3 – Using an Arithmetic Formula to Convert Millimeters to Feet and Inches

1 mm  =  0.0032808 ft

1 mm  = 0.03937 in

The distance d in inches (in) is calculated by dividing the 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 distance in feet (ft):

Feet = Inches / 12

or,

Feet = Millimeters / 25.4 / 12

STEPS:

• Select D5 and enter the formula to get the inches from millimeters.
`=C5/25.4`
• Press Enter.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

• To find  feet from millimeters, select E5.
• Use the following formula.
`=D5/12`
• Press Enter.

• Alternatively, you can use this formula:
`=C5/25.4/12`
• Press Enter.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

### Method 4 – Applying Excel VBA to Convert Millimeters (mm) to Feet (ft) and Inches (in)

STEPS:

• Go to the Developer tab.
• In Code, click Visual Basic to open the Visual Basic Editor. Or press Alt + F11 to open the Visual Basic Editor.

• You can also right-click your worksheet and go to View Code.

• Click on Module in Insert.

• Enter the VBA code shown below in the Module.

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``````
• Run the code by clicking RubSub or pressing F5.

mm are converted to feet and inches.

VBA Code Breakdown

``Sub mm_to_ft_in()``

Sub  names the procedure mm_to_ft_in().

``Dim a As Integer``

declares a variable: the integer value as a.

``````For a = 5 To 10
Cells(a, 4).Value = Application.WorksheetFunction.Convert(Cells(a, 3).Value, "mm", "ft")
Next a``````

The For Next Loop begins with row 5. The Cells property is used to write values. The VBA Convert function converts millimeters to feet.

``````For b = 5 To 10
Cells(b, 5).Value = Application.WorksheetFunction.Convert(Cells(b, 3).Value, "mm", "in")
Next b``````

5 is the start of the For Next Loop. The values are written using the Cells property. The VBA Convert function converts millimeters to inches.

``End Sub``

ends the procedure.

## Things to Remember

• You will get a #N/A! error if you use “MM”, “FT”, and “IN.”

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

1. 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?

Lutfor Rahman Shimanto Mar 7, 2024 at 11:08 AM

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”:

=ROUND(CONVERT(C5, “mm”, “ft”), 2)

“mm” to “in”:

=ROUND(CONVERT(C5, “mm”, “in”), 2)