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.

convert mm to cm in excel intro


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.

convert 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.

convert mm to cm in excel generic formula

Read More: How to Convert inch to mm in Excel (3 Simple Methods)


Similar Readings


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.

convert mm to cm in excel paste special option

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.

convert mm to cm in excel developer tab

  • 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

convert mm to cm in excel Code module

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.

Convert MM to CM in Excel Incorporating VBA

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

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo