# 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

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. 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”) 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”) 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. Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.