How To Convert CM To Inches In Excel

Microsoft Excel offers powerful conversion functionality to the user. You can apply simple equations across ranges of data to quickly produce new figures. Use this powerful feature to convert centimeters to inches in Excel.

Advertisement

Step 1

Open or create a new spreadsheet in Microsoft Excel. Select "New.." from the file menu, or press "Ctrl + N" to create the spreadsheet.

Step 2

Enter the value for centimeters to be converted In cell "A1." For example, to convert 2.54 centimeters to inches, you would enter the value "2.54" into cell "A1."

Advertisement

Step 3

Enter the following into cell "B1": = A1/2.54. This defines the equation that will be used to convert centimeters into inches. The "=" at the beginning of the line defines that cell as a function. The "A1" refers to the cell that contains your data. The "/" tells Excel to perform division. The value "2.54" is the standard conversion rate for converting centimeters to inches.

Step 4

Hit enter. The cell "B1" will display the value of centimeters converted to inches. Finishing the example, cell "A1" will display the value "2.54" for centimeters while cell "B1" will display the value "1" for inches.

TL;DR (Too Long; Didn't Read)

Enter the equation to convert centimeters to inches into any cell in the Excel spreadsheet by substituting the "A1" in the equation with the location of the cell to be converted.

Advertisement

Cite This Article

MLA

Billock, Matt. "How To Convert CM To Inches In Excel" sciencing.com, https://www.sciencing.com/how-7298256-convert-cm-inches-excel/. 7 August 2017.

APA

Billock, Matt. (2017, August 7). How To Convert CM To Inches In Excel. sciencing.com. Retrieved from https://www.sciencing.com/how-7298256-convert-cm-inches-excel/

Chicago

Billock, Matt. How To Convert CM To Inches In Excel last modified March 24, 2022. https://www.sciencing.com/how-7298256-convert-cm-inches-excel/

Recommended

Advertisement