# 2 Methods to Use Millimeter (mm) to Square Meter (m2) Formula in Excel

Suppose you have several square-shaped Exhibits with Dimensions in millimeters(mm) and you need to convert them to square meters.

### Method 1 – Using Excel CONVERT Function

Steps:

• Add a helper column to the right: Meter(m).
• Select cell D6, and add the following formula in the formula bar:
`=CONVERT(C6,"mm","m")`

Here, C6 is the starting cell of the Dimension in Millimeters (mm), mm is the second argument (from_unit) and m is the last argument (to_unit).

• Drag the Fill Handle tool rest of the cells in the column.

• Add another column to the right with the title â€˜Square Meter(m^2), which will contain the results.
• Select cell E6 and add the following formula:
`=D6*D6`

• Drag the Fill Handle tool for the rest of the column and get the dimension in square meters.

Read More: How to Convert MM to CM in Excel

### Method 2 – Inserting the Millimeter(mm) mm to Square Meter(m2) Formula Manually

Steps :

• Create a new column for Square Meter to the right.
• Select cell D6 and insert the following formula:
`=(C6/1000)^2`

• Drag the Fill Handle tool for the rest of the column.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Sowmik Chowdhury

Sowmik Chowdhuri, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a crucial Excel & VBA Content Developer at ExcelDemy. His profound passion for research and innovation seamlessly aligns with his unwavering dedication to Excel. In this role, Sowmik not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, highlighting his steadfast commitment to consistently deliver content of exceptional quality and value. Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF