How to Convert MM to CM in Excel - 4 Easy Methods

The sample dataset showcases “Name” and “Height” in Millimeter units (MM).

Use the CONVERT function to convert Millimeter to Centimeter.

Steps:

=CONVERT(C5,"mm","cm")

This will Auto-fill the formula to the selected cells.

Steps:

=C5*0.1

MM are converted to CM.

MM values will be divided by 10. 10 is added in B12.

Steps:

MM values are converted to CM in D5:D10.

Read More: Converting CM to Inches in Excel

Steps:

Alternatively, you can press ALT+F11. The Microsoft Visual Basic for Applications window will open.

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

VBA Code Breakdown

A Sub Procedure cm_to_mm_conversion is called.
D5:D10, is defined as output range.
R1C1-style refer to the range inside the CONVERT function.
RC[-1] is:
- The third Bracket [ ] is used for relative cell references.
- -1 inside the bracket means 1 less.
- -1 is next to C, which means 1 column left.
As the range is D5:D10, for this notation, C5:C10 is referred inside our formula.

MM are converted to CM.

Things to Remember

The CONVERT function is case-sensitive. MM or CM instead of mm or cm can’t be used. Otherwise, the “#N/A” error will be displayed.
Only similar measurements can be used in the CONVERT function.