...

MS Excel VBA

Convert-Inches-to-CM-formula

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

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

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

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

This short tutorial will show you how to use a simple formula to convert a value in one length measurement unit to another. If You Like This tutorial, Join Excel VBA.

CONVERT Formula in Excel

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

 

It’s the CONVERT formulas in Excel.

Below is the syntax of the CONVERT formulas:


CONVERT(number, from_unit, to_unit)

Where:

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

 

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

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

  1. Inch – “in”
  2. Feet – “ft”
  3. Meter – “m”
  4. Milimeter – “mm”
  5. Centimeter – “cm”

Now that we know what formula to use to convert Inches to a millimeter or centimeters or meters let’s look at the examples.

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

Imagine 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 Inches to MM

Below is the formula to convert Inches to Centimeter:

Convert Inches to CM formula

Below is the formula to convert Inches to Meter:

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 need to reverse the codes.

 

So the formula to convert MM to Inches would be:

Convert MM to Inches

Converting Inches to Feet

A more familiar conversion needed is between inches and feet.

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

Below is the formula to convert inches to feet:

Convert Inches to Feet formula

Learn Complete Microsoft Excel Tutorial

 

 

51 thoughts on “How to Convert Inches to MM, CM, or Feet in Excel?”

  1. SORRY BUT NO KFC AROUND HERE BUT LIKE THEIR CHECKEN WHEN IN AREA WHERE ONE IS. ESPECIALY A SIT DOWN ONE WHERE YOU RELAX AND ENJOY IT BETTER. Merlin Store

Leave a Comment

Your email address will not be published. Required fields are marked *


Scroll to Top