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.
=CONVERT(C5,"mm","cm")
- 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.
=C5*0.1
- 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
VBA Code Breakdown
- First, we are calling our Sub Procedure cm_to_mm_conversion.
- Then, we define our cell range D5:D10, which is our output range.
- After that, we used the R1C1-style notation to refer to our range inside the CONVERT function.
- Here, RC[-1] signifies –
- The third Bracket [ ] is used to denote relative cell references.
- -1 inside the bracket means 1 less.
- This -1 is next to C, which means 1 column left.
- As we have seen our cell range is D5:D10. Hence, for this notation, we are referring to the cell range C5:C10 inside our formula.
- Thus, this formula works.
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!