How to Convert Centimeters to Inches in Excel (3 Methods)

If you are learning how to convert centimeters to inches in Excel, the fastest formula is =A2/2.54, where A2 holds the centimeter value; fill it down the column to convert the whole list. One inch equals exactly 2.54 centimeters, so dividing converts every value at once. For a one-off conversion, try our free centimeters to inches converter at /convert/centimeters-to-inches/.

Method 1: Divide by 2.54 (Fastest)

The fastest way to convert centimeters to inches in Excel is the division formula =A2/2.54. Click the cell next to your first centimeter value, type =A2/2.54 (replacing A2 with your actual cell), press Enter, then double-click the small square fill handle at the cell’s bottom-right corner to copy the formula down the whole column. Excel adjusts the reference row by row, so A3/2.54, A4/2.54, and so on compute automatically. This works because one inch is defined as exactly 2.54 centimeters, making division the mathematically exact conversion with no lookup table needed. Format the result column as a number with two decimals for clean output, and keep the original centimeter column untouched so you can audit the numbers later. For a single value outside a spreadsheet, our centimeters to inches converter gives the same answer without opening Excel at all.

Using the Excel CONVERT Function for Inches

Searching for the ‘excel convert function inches’ syntax? It is =CONVERT(A2,"cm","in"). Excel’s CONVERT function is a built-in unit converter: the first argument is the value, the second is the starting unit, and the third is the target unit. The unit codes must be typed exactly as "cm" and "in" in lowercase with straight quotation marks; "CM" or curly quotes will throw a #VALUE! error. The result is identical to =A2/2.54 because CONVERT uses the same exact 2.54 definition internally. The advantage of CONVERT is readability: six months later, =CONVERT(A2,"cm","in") tells you what the formula does, while =A2/2.54 requires you to remember the constant. It also works in Google Sheets with identical syntax, so the same workbook converts in both programs. One caution: CONVERT is designed for single values, so for thousands of rows the plain division formula calculates marginally faster, though on modern machines the difference is negligible.

Method 3: Paste Special Divide (No Formulas)

If you want the inch values as static numbers with no formulas left behind, use Paste Special. Type 2.54 in any empty cell and copy it, select your centimeter values, right-click, choose Paste Special, select Divide, and click OK. Excel divides every selected cell by 2.54 in place, replacing the centimeters with inches. Delete the helper 2.54 cell afterward. This method is ideal when you are cleaning data for export, because the recipient gets plain numbers instead of formulas that break when columns move. The downside is that it destroys the original centimeter values, so copy the column to a backup sheet first if you might need them. For a handful of values it is slower than typing one formula, but for converting an existing column permanently it is the cleanest option. Remember that Paste Special divide is a one-time operation: new centimeter values added later will not convert automatically the way a formula column does.

How to Convert Inches to cm in Excel (Reverse Direction)

To convert inches to cm in Excel, multiply instead of dividing: =A2*2.54, or use =CONVERT(A2,"in","cm"). The logic mirrors the forward conversion because the inch–centimeter relationship is exact in both directions: 1 inch = 2.54 cm, and therefore 1 cm = 1/2.54 inch. This comes up constantly with product dimensions, where US suppliers quote inches and metric documentation needs centimeters. If you convert both directions in the same workbook, label every column header with its unit, such as ‘Length (cm)’ and ‘Length (in)’, because an unlabeled column is how inch values get converted twice by the next person who opens the file. For the full treatment of the reverse formula with worked examples, see our guide to the inches to cm formula. The same three methods apply: division formula in reverse, CONVERT with the units swapped, or Paste Special with Multiply instead of Divide.

The cm to Inches Formula, Explained

The cm to inches formula rests on a single exact definition: 1 inch = 2.54 centimeters, fixed by international agreement in 1959. Because the definition is exact, 1 centimeter equals 1/2.54 = 0.393700787 inches, and dividing any centimeter value by 2.54 gives the mathematically exact inch equivalent. Worked examples: 30 cm ÷ 2.54 = 11.81 inches (a standard ruler); 100 cm ÷ 2.54 = 39.37 inches; a 55 cm TV screen width ÷ 2.54 = 21.65 inches; and a height of 170 cm ÷ 2.54 = 66.93 inches, which is 5 feet 6.9 inches, normally stated as 5 feet 7 inches. Notice the pattern: dividing by 2.54 always shrinks the number, because an inch is a larger unit than a centimeter. If your result ever comes out larger than the input, you multiplied by mistake. Keep two decimal places for everyday use; more digits imply a precision your tape measure does not have.

Rounding: Show Clean Decimals Instead of 11.81102362

Raw division gives long decimals like 11.81102362, so wrap the formula in ROUND: =ROUND(A2/2.54,2) returns 11.81. The second argument sets the decimal places: 0 gives whole inches, 1 gives tenths, 3 gives thousandths for machining work. Use ROUNDUP or ROUNDDOWN when the direction of rounding matters, for example when cutting material where rounding down avoids overshooting the stock. An alternative is cell number formatting (Format Cells → Number → 2 decimals), which displays 11.81 while keeping full precision underneath; this is better when the values feed further calculations, because formatting never changes the stored value while ROUND does. Avoid the TEXT function for values you will calculate with later, since TEXT returns text that breaks downstream math. A good rule: ROUND when the rounded value is the final answer, format when the value is an intermediate step.

Converting a Whole Column at Once

For long lists, enter the formula once and fill it down: select the result cell, double-click the fill handle, and Excel copies the formula to the last adjacent row of data. In Microsoft 365 and Excel 2021 you can also use a dynamic array formula such as =A2:A100/2.54, which spills the entire converted column from one cell with no filling needed. If your centimeter values live in an Excel Table, a structured reference like =[@Length]/2.54 fills automatically into every new row you add. When the conversion factor must stay visible for auditing, put 2.54 in a dedicated cell (say $Z$1) and write =A2/$Z$1 with the absolute reference so the factor never drifts as the formula fills. Always spot-check the first and last rows after filling, because a blank cell mid-column stops the double-click fill early and leaves the tail unconverted. For very large datasets, the plain division formula is the lightest calculation Excel can run.

Areas and Volumes: Square Centimeters to Square Inches

Converting areas needs the factor squared: since 1 inch = 2.54 cm, one square inch equals 2.54² = 6.4516 square centimeters, so divide cm² values by 6.4516 to get in². For volumes, one cubic inch equals 2.54³ = 16.387064 cubic centimeters, so divide cm³ by 16.387064 to get in³. The classic mistake is dividing an area by 2.54 instead of 6.4516, which understates the result by a factor of 2.54 and ruins material estimates. In Excel: =A2/6.4516 for areas, =A2/16.387064 for volumes, or =CONVERT(A2,"cm","in") squared as =(CONVERT(A2,"cm","in"))^2 if you prefer staying with CONVERT. Floor plans and room sizes hit this constantly, which is why we also wrote a dedicated walkthrough for converting square feet in Excel, and our square feet to square meters converter handles the metric–imperial area jump directly. Label area columns with the ² symbol so nobody mistakes them for linear measurements.

Common Errors and Fixes

The #NAME? error almost always means a typo in CONVERT or straight quotes replaced by curly quotes after pasting from the web; retype the formula by hand to fix it. A #VALUE! error means Excel sees text instead of numbers: centimeter values imported from a CSV often arrive as text, so select the column, use Data → Text to Columns → Finish, or wrap with =VALUE(A2)/2.54. Remember the unit codes are case-sensitive in practice: use lowercase "cm" and "in" exactly, because "CM" fails in some Excel builds. If results look ten times too large, check for a stray extra zero or a column already in inches being converted twice; if they look 2.54 times too small, you multiplied where you should have divided. Watch for mixed units in one column, such as a few values in millimeters hiding among centimeters, which silently corrupt averages. Finally, never hard-code converted results over the original data without a backup: keep the source column, add a converted column, and hide the source if the sheet must look clean.

Google Sheets: The Same Formulas Work

Everything in this guide works in Google Sheets with no changes: =A2/2.54, =CONVERT(A2,"cm","in"), and Paste Special divide (Edit → Paste special → Divide) all behave the same. For whole columns, Sheets users can use =ARRAYFORMULA(A2:A/2.54) to convert an entire column from a single cell, which is Sheets’ equivalent of Excel’s dynamic arrays. CONVERT is fully supported in Sheets, including the same "cm" and "in" unit codes, so workbooks shared between Excel and Sheets users convert identically. One Sheets-specific gotcha: locale settings change the formula separator, so in many European locales you must write =CONVERT(A2;"cm";"in") with semicolons instead of commas. If a shared sheet throws errors on a colleague’s machine, the separator is the first thing to check. Rounding, formatting, and fill-down all transfer as well, making the cm-to-inches workflow genuinely portable.

When to Skip Excel and Use a Converter Instead

Excel is the right tool for lists, but for a single measurement it is overkill: opening a spreadsheet to convert one height or one screen size wastes more time than the conversion saves. For one-off values, our free centimeters to inches converter gives the exact answer in one step, on any device, with no formula to remember. The same judgment applies to other everyday conversions: our miles to kilometers converter uses the same multiply-by-a-constant pattern (× 1.609344) for road distances, and our guide to the kilograms to pounds formula covers the weight equivalent. A practical workflow is to use the web converter for quick checks while drafting, then move to Excel formulas once you have a real dataset to process. Either way the underlying math is identical: one exact constant, applied consistently, with units labeled on every column.