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.
- Inch – “in”
- Feet – “ft”
- Meter – “m”
- Milimeter – “mm”
- 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:
Below is the formula to convert Inches to Centimeter:
Below is the formula to convert Inches to Meter:
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:
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:
Learn Complete Microsoft Excel Tutorial
I got what you intend,saved to favorites, very decent internet site. Lenny Trenholm
This post is genuinely a pleasant one it assists new web visitors, who are wishing in favor of blogging. Frank Rasmusson
Thanks for sharing, this is a fantastic post. Much thanks again. Awesome. Son Loken
If you desire to increase your familiarity simply keep visiting this website and be updated with the latest news update posted here. Rob Heredia
I am not rattling wonderful with English but I get hold this really easygoing to translate. Wyatt Pharris
What a data of un-ambiguity and preserveness of precious know-how regarding unpredicted feelings. Giovanni Chiapetti
Appreciation to my father who stated to me concerning this weblog, this weblog is truly remarkable. Delmar Carboni
Greate post. Keep posting such kind of info on your page. Gil Lavergne
Hello. This article was extremely remarkable, particularly since I was looking for thoughts on this topic last Friday. Deshawn Mirafuentes
Perfect piece of work you have done, this site is really cool with great info . Mitch Rodvold
There is visibly a bunch to realize about this. I believe you made certain nice points in features also. Freddy Trout
Excellent, what a blog it is! This web site gives valuable facts to us, keep it up. Kieth Hazy
Thanks, I ave been hunting for facts about this topic for ages and yours is the best I ave found so far. Stuart Arhart
I think the admin of this web page is genuinely working hard for his site, since here every data is quality based stuff. Coy Fauerbach
I am truly thankful to the owner of this site who has shared this great piece of writing at here. Tyler Geitner
Some truly prime content on this internet site , saved to bookmarks . Norris Swiderski
I was reading some of your content on this website and I conceive this internet site is very instructive! Retain posting. Emmitt Tyrus
Knowing how to use SEO tools is going to help you to have a higher ranked webpage which will bring in more viewers. Roland Moes
Way cool! Some very valid points! I appreciate you writing this post plus the rest of the site is really good. Floyd Rayfield
Im thankful for the post. Much thanks again. Awesome. Rusty Cossel
There is definately a lot to know about this topic. I love all of the points you have made. Zachery Klimas
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
Simply wanna comment on few general things, The website design is perfect, the subject matter is rattling superb : D. Jeffrey Abarca
I love being near waterfalls! There are beautiful falls in Vermont. Wayne Laranjo
Hello there brothers, how are you, and what you wish to say about this object, in my view its honestly amazing for our. Jesse Herling
Way cool! Some extremely valid points! I appreciate you writing this article plus the rest of the site is also really good. Julius Cockett
Some truly great blog posts on this website , thanks for contribution. Michael Vanderweerd
I regard something truly interesting about your site so I saved to favorites . Nick Ballon
Absolutely pent content, Really enjoyed looking through. Jerrell Litehiser
I loved your blog article. Really looking forward to read more. Want more. Augustine Perini
Goood article. I am facing many of these issues aas well.. Kevin Bussen
Oh my goodness! Impressive article dude! Thanks, However I am going through troubles with your RSS. Kareem Hutchin
It is in reality a nice and helpful piece of info. Truman Kazemi
What a stuff of un-ambiguity and preserveness of precious knowledge on the topic of unexpected feelings. Alvin Pillo
The more you spend outside in charges, the less you will need to invest in your future. Johnson Murphrey
Really enjoyed this blog article. Thanks Again. Much obliged. Frank Linden
Find your favorite cigarettes with cheap prices and get free shipping to your door. Emanuel Glee
I quite like looking through an article that will make men and women think. Also, many thanks for permitting me to comment. Andrea Blush
As soon as I discovered this internet site I went on reddit to share some of the love with them. Faustino Bjorn
Thank you, Marc and Angel, for sharing that beautiful, powerful story! Thank you for all that you do. Marcelo Maltz
There is definately a lot to know about this topic. I love all of the points you have made. Lauren Amici
I have read so many articles concerning the blogger lovers except this article is actually a fastidious article, keep it up. Norbert Lokker
For most recent news you have to pay a quick visit internet and on the web I found this web page as a finest site for most recent updates. Duncan Pinick
My brother recommended I might like this blog. He was enfirely right. Marcus Keipe
Hiya very nice blog!! Man .. Beautiful .. Wonderful .. Randy Biehl
Make sure that you have SEO friendly themes, plug-ins and templates. Ellis Dage
This is really attention-grabbing, You are an overly skilled blogger. Shannon Volkens
Only wanna state that this is invaluable , Thanks for taking your time to write this. Darren Redhouse
I am sure this piece of writing has touched all the internet people, its really really nice piece of writing on building up new weblog. Quentin Norley
Hello. This article was really interesting, particularly since I was looking for thoughts on this subject last Monday. Sheldon Tomaino
As soon as I discovered this internet site I went on reddit to share some of the love with them. Russell Wendlandt