How to Convert Inches to MM, CM, or Feet in Excel? Easy Formula

If you work with measurement data and there is a need to convert the data from one length measurement unit to another, you can use some inbuilt formulas in excel to do that.

For example, you may have a need to convert data in centimeters/millimeters to inches or feet.

In this short tutorial, I will show you how to use a simple formula to convert a value in one length measurement unit to another.

So let’s get started!

CONVERT Formula in Excel

Before I show you how to convert data from one unit to another, let me quickly introduce the formula that is going to help us do that.

It’s the CONVERT formula in Excel.

Below is the syntax of the CONVERT formula:

CONVERT(number, from_unit, to_unit)

Where:

  • number is the value that you want to convert from one measurement unit to another
  • from_unit is the code for the measurement unit in which you already have the number
  • to_unit is the code for the measurement unit in which you want the number to be converted

While it’s a simple formula, you do need to know the right measurement codes that you can use in the formula.

Below are some of the codes we will be using in this tutorial.

  • Inch – “in”
  • Feet – “ft”
  • Meter – “m”
  • Milimeter – “mm”
  • Centimeter – “cm”

If you want a full list of all the code (for various categories such as weight, distance, time, pressure, force, energy, power, etc), you can check it out here.

Now that we know what formula to use to convert Inches to a millimeter or centimeter or meter, let’s have a look at the examples.

Converting Inches to Millimeter (MM), Centimeter (CM), Meter (M), or Feet

Suppose you have a dataset as shown below and you want to convert the values in inches into MM, CM, and M

Below is the formula to convert Inches to Millimeter:

=CONVERT(A2,"in","mm")
Convert Inches to MM

Below is the formula to convert Inches to Centimeter:

 =CONVERT(A2,"in","cm") 
Convert Inches to CM formula

Below is the formula to convert Inches to Meter:

 =CONVERT(A2,"in","m") 
Convert inches to meter formula

And in the same way, if you want to do the reverse – i.e., to convert MM or CM to Inches – you just need to reverse the codes.

So the formula to convert MM to Inches would be:

 =CONVERT(A2,"mm","in") 
Convert MM to Inches

Converting Inches to Feet

A more common conversion needed is between inches and feet.

Again, you can use the same formula with the right measurement codes as the from_unit and to_unit.

Below is the formula to convert inches to feet:

  =CONVERT(A2,"in","ft")  
Convert Inches to Feet formula

Some Important Things to Know about the Convert Formula

  • In case you use an incorrect from_unit or to_unit code, the fromula will return a #N/A error
  • You can only convert a value in the same group of measurement. For example, if you’re dealing with millimeter and centimeter values, then these are in the distance group. You can only convert a value from this group into another value in the group. In case you try conversion in different group, it will give you a #N/A error
  • While you’re entering the formula, Excel helps you by showing all units that are available to use and you can then choose from the intellisense. I don’t know why, but “mm” and “cm” are not part of the list it shows, but these still work in the formula.
  • The unit codes/names are case sensitive. So you can not use “MM” or “CM” instead of “mm” or “cm”. If you do, it gives the #N/A error

While I have only covered a part of the CONVERT formula and showed you how to convert MM or CM or Feet to Inches (or vice-versa), you can do some very useful other conversions as well (such as Grams/Kilograms to Pound or Feet to Yard).

I hope you found this tutorial useful!

Other Excel tutorials you may also like:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment