How to Convert MM to CM in Excel (4 Easy Methods)

In this article, we will show you 4 methods of how to convert MM to CM in Excel. To demonstrate our methods, we have taken a dataset consisting of 2 columns: “Name” and “Height(MM)”. In our dataset, we have shown the height of 6 individuals in Millimeter units, which we will convert to Centimeter units.

How to Convert MM to CM in Excel: 4 Methods

1. Using CONVERT Function to Convert MM to CM in Excel

For the first method, we will use the CONVERT function to convert Millimeter to Centimeter.

Steps:

• First, select the cell range E5:E10.
• Secondly, type the following formula.

• Finally, press CTRL+ENTER.

This will Auto-fill the formula to the selected cells. Thus, we have shown you the very first method of converting MM to CM in Excel.

Read More: Millimeter(mm) to Square Meter Formula in Excel

2. Convert MM to CM by Applying Generic Formula

For the second method, we will use a generic formula to convert MM to CM. More specifically, we will multiply by 0.1 to achieve our goal.

Steps:

• First, select the cell range E5:E10.
• Secondly, type the following formula.

• Finally, press CTRL+ENTER.

Thus, we will convert MM to CM in Excel using a generic formula.

Read More: How to Convert Meters to Feet in Excel

3. Use of Paste Special Feature to Convert MM to CM

In this section, we are going to use the Paste Special feature to convert MM to CM in Excel. We will divide the MM values by 10 in this method. Therefore we have added 10 on cell B12. Let us see how we can do this.

Steps:

• First, copy 10 from cell B12.
• Secondly, select the cell range D5:D12.
• Thirdly, from the Home tab >>> Paste >>> select “Paste Special…”.

Then, the Paste Special dialog box will appear.

• After that, select Divide from the Operation section.
• Finally, press OK.

After that, it will convert MM values to CM in the cell range D5:D10.

Read More: Converting CM to Inches in Excel

4. Convert MM to CM in Excel Incorporating VBA

For the last method, we will use an Excel VBA to convert MM to CM. Moreover, we are going to use the FormulaR1C1 property to implement relative cell reference in our code. Finally, we will use the standard CONVERT function inside our code to achieve our task.

Steps:

Before, typing our code we need to bring up the VBA Module. To do that –

• First, from the Developer tab >>> select Visual Basic.

Alternatively, you can press ALT+F11 to do this too. The Microsoft Visual Basic for Applications window will appear after this.

• Secondly, from Insert >>> select Module.

Here, we will type our code.

• Thirdly, type the following code inside the Module.

Sub cm_to_mm_conversion()
    Range("D5:D10").Select
    Selection.FormulaR1C1 = "=CONVERT(RC[-1],""mm"",""cm"")"
End Sub

Now, we will execute our code.

• First, Save this Module.
• Secondly, click inside our code.
• Finally, press the Run button.

Thus, we will convert MM to CM in Excel using a VBA code. Therefore, we have concluded by showing you the 4 methods of how to convert these two distances.

Read More: How to Convert CM to Feet and Inches in Excel

Things to Remember

• First, the CONVERT function is case-sensitive. Therefore we cannot use MM or CM instead of mm or cm inside the function. If we input the wrong case, we will get a “#N/A” error.
• Secondly, you can convert only similar measurements using the CONVERT function. That means, distance to distance is ok, but the distance to volume will not be ok.
• Thirdly, mm and cm is not listed on the Function AutoComplete Menu. However, it will work if we input everything correctly.

Practice Section

We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.

Download Practice Workbook

Conclusion

We have shown you 4 quick-and-easy methods of how to convert MM to CM in Excel. If you face any problems regarding these methods or have any feedback for me, feel free to comment below. Thanks for reading, keep excelling!

Related Articles

• How to Convert Meters to Miles in Excel
• How to Convert Square Feet to Square Meters in Excel
• How to Convert Feet to Meters in Excel
• Convert Cubic Feet to Cubic Meters in Excel
• How to Convert Lbs to Kg in Excel
• How to Convert Kg to Lbs in Excel
• How to Convert Radians to Degrees in Excel

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