How to Convert Inches to Centimeters
When working with spreadsheets that involve product dimensions, technical specifications, or global reporting, you’ll often need to convert measurements between units. One of the most common needs is converting inches to centimeters in Excel—especially when switching between imperial and metric systems.
Instead of using manual calculators, Excel provides several efficient ways to handle these conversions. Whether you’re converting one cell or creating a dynamic conversion tool, Excel makes it easy to switch between inches, centimeters, millimeters, and more.
Table of Contents
Manual Formula to Convert Inches to Centimeters
One of the simplest ways to convert inches to centimeters is by applying a basic multiplication formula. Since 1 inch equals exactly 2.54 centimeters, just multiply the inch value by 2.54.
=C2*2.54
To convert centimeters back to inches, divide the value by 2.54:
=C5/2.54
This manual approach is easy to remember and works well when dealing with a few values.
Convert Inches to Centimeters Using the CONVERT Function
Excel offers a built-in function called CONVERT, which lets you convert values between various units—length, weight, temperature, and more.
For length conversions, Excel uses unit codes like:
Inches = “in”
Centimeters = “cm”
To convert inches to centimeters:
=CONVERT(B5,"in","cm")
To reverse the conversion (centimeters to inches):
=CONVERT(B9,"cm","in")
You can also convert feet to centimeters or millimeters using:
=CONVERT(A2, “ft”, “cm”)
=CONVERT(A2, “ft”, “mm”)
Dynamic Method Using VLOOKUP + CONVERT
For more flexible conversions, especially when allowing users to choose units from a dropdown, you can combine CONVERT with VLOOKUP. This allows users to select units like “Inch” or “Centimeter” from a list, and the formula automatically finds the right unit code.
Here’s a dynamic formula that uses VLOOKUP to fetch the correct unit codes from a reference table (Length.Table):
=CONVERT(B15,VLOOKUP(B16,Length.Table,2,0),VLOOKUP(D16,Length.Table,2,0))
B15 = value to convert
B16 and D16 = dropdowns for units (e.g., “Inch”, “Centimeter”)
Length.Table = named range with unit names and codes
This method is great for creating interactive conversion tools in your spreadsheets.
Real-World Use Cases
E-commerce: Convert product dimensions from inches to centimeters in Excel for global listings and marketplace requirements.
This ensures consistent sizing and saves time during bulk uploads.Architecture & Engineering: Switch between inch and centimeter measurements in Excel for international design and construction standards.
Helps meet client expectations and local code compliance.Logistics & Shipping: Use Excel to convert inches to centimeters for package dimensions, shipping labels, and customs documentation.
Ensures accurate freight charges and avoids costly errors.Academics & Research: Students and researchers use Excel to convert experimental or measurement data into metric units.
This streamlines reporting and follows academic standards.Manufacturing & QC: Excel simplifies converting inches to centimeters for product inspection and standardization across global teams.
Ensures quality control data matches metric specs.Graphic Design & Printing: Designers convert layout sizes from inches to centimeters in Excel for accurate print specifications.
Prevents misalignment in brochures, posters, and packaging.
Common Issues & Quick Fixes
Issue 1: CONVERT function not available?
Make sure you’re using Excel 2007 or later.
Issue 2: Wrong result from VLOOKUP formula?
Double-check the named range (Length.Table) and make sure it includes proper short codes (like “cm”, “in”).
Issue 3: Getting #N/A?
Your dropdown may not match the exact spelling of unit names in the lookup table.
Final Thoughts
These simple methods make it easy to convert inches to centimeters in Excel—whether you’re doing quick calculations or building a full conversion tool. If you have any other smart ways to handle unit conversions in Excel, feel free to share them in the comments!
And if you found this article helpful, don’t forget to share it with your Excel-loving friends.
