# How to Convert MM to Inches in Excel 2013

Converting units of measurement is a necessary evil for a lot of people in a wide variety of fields. Use these steps to convert millimeters to inches in Excel 2013.

2. Click inside the cell where you want to display inches.
3. Type the formula =CONVERT(XX, “mm”, “in”) but replace “XX” with the cell containing the millimeter value.
4. Press Enter to perform the conversion.

Our article continues below with additional information and pictures of these steps.

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

You may notice, such as in my screenshot above, that you are seeing a lot of decimal place values.

You can modify the number of displayed decimal places by right-clicking a cell, choosing Format Cells, then clicking Number and specifying the desired number of decimal places.

Note that the values in inches are being displayed as a formula. If you copy and paste those values to another location, you might run into an issue. You can resolve this by pasting as a value instead of a formula. If you select the Paste button on the Home tab you will see that option among the different paste actions.

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.