

This article was first published on Novemand has been updated for clarity and content. There are also other units you can use with the CONVERT function. For example, type =CONVERT(A2,"in","cm").

The CONVERT function uses the following syntax: =CONVERT(Cell to convert,Units to convert from,Units to convert to). You can also use the CONVERT function to convert measurements. Type =cell to convert*2.54 (for example =A2*2.54).Shown as 0.39 after rounding to the nearest hundredth. To convert from inches to cm by multiplying: If a baby is 64 centimeters long, what is her length in inches The answer is 25 inches. Centimeter to inches formula and conversion factor.
CM TO INCHES CALCULATOR DOWNLOAD
In the following example, the conversion formula is entered in column B: Use a simple formula, the CONVERT function or download our free unit converter to convert from cm to inches or vice. According to the modern definition, one inch is equal to 25.4 mm exactly. Click in a cell where you want to insert the converted amount.To convert from cm to inches by dividing: The following are the conversion amounts:ġ cm = 0.3937 inch Divide to convert from cm to inches

CM TO INCHES CALCULATOR HOW TO
Recommended articles: How to Hide Formulas from Clients, Colleagues and Other Usersĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > This is useful since the regional settings on a computer affect the default measurement system used in Excel and other programs. You can convert cm to inches (inches to centimeters or centimetres) using formulas with operators or functions in Excel. Easily convert centimeters to inches, one-click copy of the result. Convert Inches to Centimeters or Vice Versa in Excel Worksheetsīy Avantix Learning Team | Updated October 14, 2022Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019, 2021 and 365 (Windows)
