In this Excel Convert Cm to Inches Tutorial, you learn how to create an Excel convert cm to inches formula.
This Excel Convert Cm to Inches Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by clicking the button below.
Table of Contents
Related Excel Training Materials and Resources
This Excel Convert Cm to Inches Tutorial is part of a more comprehensive series of Excel Measurement System Conversion Tutorials.
- Excel Convert Cm to Inches: Click here to open.
- Excel Convert Celsius to Fahrenheit: Click here to open.
You can find more Excel and VBA Tutorials in the organized Tutorials Archive: Click here to visit the Archives. The following are some of my most popular Excel Tutorials and Training Resources:
- Excel Keyboard Shortcuts Cheat Sheet: Click here to open.
- Excel Power Query (Get & Transform) Tutorial for Beginners: Click here to open.
- Excel Macro Tutorial for Beginners: Click here to open.
If you want to learn more about Excel essentials, Excel formulas, and similar Excel topics, you may be interested in taking one (or more) Excel Courses: Click here to learn more about these Excel Courses (affiliate link).
If you want to learn how to automate Excel (and save time) by working with macros and VBA, you may be interested in the following Premium Excel Macro and VBA Training Materials:
- Premium Courses at the Power Spreadsheets Academy: Click here to open.
- Books at the Power Spreadsheets Library: Click here to open.
If you need help with Excel tasks/projects, you may be interested in working with me: Click here to learn more about working with me.
Excel Convert Cm to Inches Formula Template/Structure
'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-convert-cm-inches/
=CONVERT(NumberOfCentimeters,"cm","in")
Step-by-Step Process to Create an Excel Convert Cm to Inches Formula
(1) Call the CONVERT function.
'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-convert-cm-inches/
=CONVERT(...)
(2) Set the first argument of the CONVERT function (number) to the number of centimeters you convert to inches.
'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-convert-cm-inches/
=CONVERT(NumberOfCentimeters,...)
(3) Set the second and third arguments of the CONVERT function (from_unit and to_unit) to the following strings:
- from_unit: “cm”.
- to_unit: “in”.
'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-convert-cm-inches/
=CONVERT(NumberOfCentimeters,"cm","in")
How (and Why) the Convert Cm to Inches Formula Works
1 inch is equal to 2.54 centimeters. You can (therefore) convert cm to inches (in Excel) by dividing the applicable number of cm by 2.54.
'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-convert-cm-inches/
=NumberOfCentimeters/2.54
Excel (however) has a built-in function to handle conversions from one measurement system to another: CONVERT.
You can (therefore) convert cm to inches by:
- Calling the CONVERT function; and
- Specifying the 3 arguments of the CONVERT function:
- number: The number of centimeters you convert to inches.
- from_unit: “cm”.
- to_unit: “in”.
Excel Convert Cm to Inches Example Formula
This Excel Convert Cm to Inches Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by clicking the button below.
Excel Convert Cm to Inches Example Worksheet
The example worksheet has 1 table/section with the following characteristics:
- Column A: Cells A6 to A16 store integers from 1 to 10.
- Column B: Cells B6 to B16:
- Store the convert cm to inches example formulas; and
- Display the results.
- Column C: Cells C6 to C16 display the convert cm to inches example formulas I enter in column B.
Excel Convert Cm to Inches Example Formula
The convert cm to inches example formula stored in cell B7 is as follows:
'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-convert-cm-inches/
=CONVERT(A7,"cm","in")
The number of centimeters I convert to inches (stored in cell A7) is 1.
Download the Excel Convert Cm to Inches Example Workbook
This Excel Convert Cm to Inches Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by clicking the button below.
Related Excel Training Materials and Resources
This Excel Convert Cm to Inches Tutorial is part of a more comprehensive series of Excel Measurement System Conversion Tutorials.
- Excel Convert Cm to Inches: Click here to open.
- Excel Convert Celsius to Fahrenheit: Click here to open.
You can find more Excel and VBA Tutorials in the organized Tutorials Archive: Click here to visit the Archives. The following are some of my most popular Excel Tutorials and Training Resources:
- Excel Keyboard Shortcuts Cheat Sheet: Click here to open.
- Excel Power Query (Get & Transform) Tutorial for Beginners: Click here to open.
- Excel Macro Tutorial for Beginners: Click here to open.
If you want to learn more about Excel essentials, Excel formulas, and similar Excel topics, you may be interested in taking one (or more) Excel Courses: Click here to learn more about these Excel Courses (affiliate link).
If you want to learn how to automate Excel (and save time) by working with macros and VBA, you may be interested in the following Premium Excel Macro and VBA Training Materials:
- Premium Courses at the Power Spreadsheets Academy: Click here to open.
- Books at the Power Spreadsheets Library: Click here to open.
If you need help with Excel tasks/projects, you may be interested in working with me: Click here to learn more about working with me.