Converting CM to Inches in Excel (2 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we need to convert centimeters (cm) to inches in Excel. In this article, I am going to show you 2 essential methods in Excel for converting cm to inches in Excel.


Converting CM to Inches in Excel: 2 Methods

This is the dataset that I am going to use to demonstrate the methods. I have some students along with their heights in centimeters. I will convert these heights to inches.

converting cm to inches in excel

Let’s move to the methods.


1. Divide CM by 2.54 to Convert CM into Inches

The relation between centimeter and inch is as follows
1 inch = 2.54 cm

So, we can convert from centimeter to inch by dividing the number (in cm) by 2.54

Steps:

  • Go to cell D5. Write down the formula
=C5/2.54

  • Press ENTER. Excel will return the output.

converting cm to inches in excel

  • Now use the Fill Handle to AutoFill up to D11.

Read More: How to Convert MM to CM in Excel


2. Apply CONVERT Function for Converting CM to Inches

Now I will use the CONVERT function to convert centimeters to inches.

Steps:

  • Go to cell D5 and write down the following formula
=CONVERT(C5,"cm","in")

converting cm to inches in excel

Meanwhile, while writing this formula, Excel will show you the list of units. You can choose from them or write manually.

  • Now, press ENTER. You will get the result.

converting cm to inches in excel

  • Now use the Fill Handle to AutoFill up to D11.

Read More: How to Convert Feet to Meters in Excel


Things to Remember

  • The relation between centimeter and inch is 1 inch = 2.54 cm

Download Practice Workbook

You can use this practice workbook while going through this article.


Conclusion

In this article, I have demonstrated 2 effective methods in Excel to convert centimeters (cm) to inches. I hope it helps everyone. And lastly, if you have any kind of suggestions, ideas, or feedback please feel free to comment down below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo