Millimeter(mm) to Square Meter Formula in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Unit conversion is one of those frequent tasks that we do in our day-to-day lives. Sometimes, we may need to use the millimeter(mm) to square meter formula in Excel to perform a large task quickly and efficiently. This article demonstrates how to use the Millimeter to square meter formula in Excel.


General Formula to Calculate Millimeter(mm) to Square Meter (m2)

To calculate square meters from millimeters the following formula can be used.

X=(Y/1000)2

In this formula,

  • X is the value in square meters.
  • Y is the value in millimeters.

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

Suppose, you have several Exhibits with Dimensions in millimeters(mm) and you need to convert them to square meters. You can easily do this within seconds by using Excel in two different methods.

mm to square meter formula in excel datasheet

In the following stages of this article, I will show you two methods, one using the CONVERT function and the other by inserting the formula manually, to get the dimensions in square meters from millimeters.

1. Using Excel CONVERT Function

The CONVERT function is a built-in function in Excel that helps in unit conversions. Though you cannot convert millimeters to square meters directly with the help of this function, you can do this by adding a simple step.

Steps:

  • First, add a column to the right with the title Meter(m).
  • Then 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).

mm to square meter using CONVERT function

  • Now, drag the Fill Handle tool rest of the cells in the column.

mm to square m convert function

  • At this point, add another column to the right with the title ‘Square Meter(m^2)
  • After that, select cell E6 and add the following formula.

Here, E6 is the starting cell for the Square Meter(m^2) column. Also, we used D6*D6 to multiply the units in meters to get in square meters.

=D6*D6

mm to square meter using CONVERT function in Excel

  • Finally, drag the Fill Handle tool for the rest of the column and you get your dimension in square meters.

mm to square m convert function

Read More: How to Convert MM to CM in Excel


2. Inserting the Millimeter(mm) mm to Square Meter(m2) Formula Manually

In this method, you will enter one formula manually, and with fewer steps you can get your required output in square meters.

Steps :

  • First of all, create a new column for the Square Meter right next to the Millimeter
  • In the next step, select cell D6 and insert the following formula.
=(C6/1000)^2

Here, D6 is the starting cell for the Square Meter(m^2) column. In the formula, we use ‘C6/1000’ to convert millimeters into meters and then we square the result to get it in square meters.

mm to square meter inserting formula manually

  • At last, drag the Fill Handle tool for the rest of the column and you will get your dimensions in square meters.

mm to square meter inserting formula manually

Read More: Convert Cubic Feet to Cubic Meters in Excel


Download Practice Workbook


Conclusion

Finally, following the same methods, you can transform any metric unit into derived square units by just knowing the general formula. I hope you get what you need from the article. Please feel free to ask any questions in the comment box below. We will get back to your questions as soon as possible.


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sowmik Chowdhury
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo