How to Convert MM to Inches in Excel 2013

Learning how to convert from MM to inches in Excel 2013 is a handy skill to have if your work or school commonly puts you in situations where you have spreadsheets containing measurements that are in the wrong units. Excel’s CONVERT formula can resolve this problem quickly, allowing you to get your data into more useful units.

The CONVERT formula also has the added benefit of keeping your original data intact, in case you need the measurements in their original format later. But you can elect to hide your rows or columns with the original data if you think it could create confusion. Hiding is preferable to deletion in this situation, as it will still leave the data intact for the formula.


Convert Millimeters to Inches in Excel 2013

This article is going to show you how to take data that is stored in your spreadsheet as millimeters and convert it to inches. It will take advantage of the CONVERT formula in Excel 2013, which is something that has the ability to convert from a lot of different units of measurement. You can learn more about the CONVERT formula here.


Step 1: Open the spreadsheet containing the MM units that you want to convert.


Step 2: Click inside the cell where you want to display the converted value.

select the cell to display the converted value



Step 3: Type =CONVERT(XX, “mm”, “in”) into the cell. XX is the location of the MM value that you want to convert. In the example image below, the cell I want to convert is cell A2, so my formula would be =CONVERT(A2, “mm”, “in”)

enter the convert formula



You can then apply your formula to other cells in the column by clicking the handle at the bottom-right corner of the cell, then dragging it down. Excel will automatically populate the selected cells with the formula, and will update the target cell relative to the original formula. So, for example, the formula in cell B3 would be adjusted to =CONVERT(A3, “mm”, “in”)

apply the formula to other cells


There are a lot of other useful formulas in Excel 2013, such as the average formula. This is a quick way to find the average value of a group of cells with a minimal amount of work. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.