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.
Download Practice Workbook
You can use this practice workbook while going through this article.
2 Suitable Methods of Converting CM to Inches in Excel
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.
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.
- Now use the Fill Handle to AutoFill up to D11.
Read More: How to Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)
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")
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.
- Now use the Fill Handle to AutoFill up to D11.
Read More: How to Convert Inches to Feet and Inches in Excel (5 Handy Methods)
Things to Remember
- The relation between centimeter and inch is 1 inch = 2.54 cm
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
- How to Convert Feet to Meters in Excel (4 Simple Methods)
- Convert Meters to Miles in Excel (3 Simple Methods)
- How to Convert Decimal Feet to Feet and Inches in Excel (3 Methods)
- Convert Meters to Feet in Excel (4 Useful Methods)
- How to Convert inch to mm in Excel (3 Simple Methods)
- Convert Kg to Lbs in Excel (4 Easy Methods)
- How to Convert Units in Excel (3 Handy Methods)