Rafiul Haq
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.
Download Practice Workbook
4 Ways to Convert MM to CM in Excel
1. Using CONVERT Function to Convert MM to CM in Excel
For the first method, we will use the CONVERT function to convert the 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 AutoFill the formula to the selected cells. Thus, we have shown you the very first method of converting MM to CM in Excel.
Read More: How to Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)
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 inch to mm in Excel (3 Simple Methods)
Similar Readings
- How to Convert Inches to Feet and Inches in Excel (5 Handy Methods)
- Convert Square Feet to Square Meters in Excel (2 Quick Methods)
- How to Convert Feet and Inches to Decimal in Excel (2 Easy Methods)
- Millimeter(mm) to Square Meter Formula in Excel (2 Easy Methods)
- How to Convert Inches to Square Feet in Excel (2 Easy Methods)
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 cell range D5:D10.
Read More: Converting CM to Inches in Excel (2 Simple Methods)
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 Application” 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 (3 Effective Ways)
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.
Conclusion
We have shown you 4 quick-and-easy to understand 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. Moreover, you can visit our site Exceldemy for more Excel-related articles. Thanks for reading, keep excelling!
Related Articles
- How to Convert Feet to Meters in Excel (4 Simple Methods)
- Convert Meters to Miles in Excel (3 Simple Methods)
- How to Convert Decimal Feet to Feet and Inches in Excel (3 Methods)
- Convert Meters to Feet in Excel (4 Useful Methods)
- How to Convert Feet to Inches in Excel (4 Quick Methods)
- Convert Cubic Feet to Cubic Meters in Excel (2 Easy Methods)
