How to Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)

Unit conversion is one of those tasks that we perform in our day-to-day lives. In many situations, you may need to convert millimeters (mm) to inches (in). To perform this type of task you can always use Microsoft Excel. This article will show you 3 methods of how to convert millimeters (mm) to inches (in) in Excel.

Arithmetic Formula to Convert Millimeter (mm) to Inches (in)

To get Inches (in) from Millimeter (mm) the following formula can be used:

X= Y*(1/25.4)


  • X is the dimension is Inches (in)
  • Y is the dimension in Millimeters (mm)

How to Convert Millimeters (mm) to Inches (in) in Excel: 3 Methods

Suppose, you have a number of wooden blocks. You have their lengths in Millimeters(mm) units. Now, you want to convert them into Inches (in) units. I will show you 3 quick methods to do this.

how to convert mm to inches dataset

1. Using the Excel CONVERT Function to convert Millimeter (mm) to Inches (in)

The CONVERT function is a built-in function in Excel that helps you with unit conversions. Now, follow the following steps to get Inches (in) from Millimeters (mm) using the CONVERT function.

Steps :

  • First, add a column next to the Millimeters (mm) column for Inches (in).
  • Next, select cell D6 and put the following formula.

Here, C6 is the starting cell of the Length in Millimeters (mm), “mm” is the second argument (from_unit), and “in” is the last argument (to_unit). Also, D6 is the starting cell for the Inches (in) column.

using convert function

  • Finally, drag the Fill Handle for the rest of the Inches (in) column and you will get your results in inches.

Using convert function mm to in

Read More: How to Convert inch to mm in Excel

2. Using the Arithmetic Formula for Conversion from Millimeter(mm) to Inches (in)

In this method, we will find the dimension in Inches (in) from Millimeters (mm) by inserting the arithmetic formula manually. Now, follow the quick steps mentioned below.

Steps :

  • At the very beginning, add a column next to the Millimeter (mm) column for Inches (in).
  • Now, click on cell D6 and type in the following formula.

using arithmetic formula

  • At this point, drag the Fill Handle for the rest of column D. Finally, you will get your results.

using arithmetic formula

Read More: How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel

3. Using VBA to convert Millimeter (mm) to Inches (in)

This method includes the use of VBA code to convert Millimeters (mm) to Inches (in). Now, follow the following steps to get your result.


  • First of all, add a column next to the Millimeter (mm) for Inches (in).

using VBA to convert

  • Now, press ALT+ F11 to open the Visual Basic window.
  • At this point sequentially select, Sheet 4 > Insert > Module
  • Then, copy the following code and paste it into the blank space.
'This Code will help you to convert mm to inch
Sub Convertmm2in()
    Dim Rg As Range
    Dim Lastrow As Long
    'Here we are asking VBA to find out the last cell in the column with a value
    Lastrow = Range("C" & Rows.Count).End(xlUp).Row
    'These lines of code select the value in the millimeter column.
    'Then it puts the inches value in the inches column multiplying mmm by 1/25.4.
    For Each Rg In Range("C6:C" & Lastrow).SpecialCells(xlCellTypeVisible)
        Range("D" & Rg.Row).Value = Range("C" & Rg.Row).Value * 1 / 25.4
End Sub

using VBA to convert

  • Next, press F5 to run the code.

Here, the entire process is shown in the following screenshot.

using VBA to convert

  • After that, a box will appear like the figure below. Then, select Convertmm2in and hit the Run button.

using VBA to convert

  • Lastly, running the code will give you the following results.

using VBA to convert mm to inch (in)

Read More: How to Convert Inches to Cm in Excel

Things to Remember While Using CONVERT Function

  • Keep in mind that the unit codes or names are case-sensitive. If you use “MM” and “IN”, you will get a #N/A Error.
  • When you are writing the formula, Excel will show you a list of available units. Though “mm” is not a part of that list, it will work just fine.
  • If you make any mistake while entering the formula, for example: not following the exact format, you will get the #N/A Error in return.

Download Practice Workbook

You can download the practice workbook from the link below.


I hope you found what you were looking for in this article. If you have any queries, please leave a comment below.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Sowmik Chowdhury
Sowmik Chowdhury

Sowmik Chowdhuri, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a crucial Excel & VBA Content Developer at ExcelDemy. His profound passion for research and innovation seamlessly aligns with his unwavering dedication to Excel. In this role, Sowmik not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, highlighting his steadfast commitment to consistently deliver content of exceptional quality and value. Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF