Cm to inches



You can convert cm to inches using formulas with operators or functions in Excel. This is useful since the regional settings on a computer affect the default measurement system used in Excel and other programs.


How to Convert Cm to Inches in Excel



Converting cm to inches by Divide


To convert from cm to inches by dividing:
  1. Click in a cell where you want to insert the converted amount.
  2. Type =cell to convert/2.54 (for example =A2/2.54)
  3. Press Enter.

Conversion formula is entered in column B:

Convert cm to inches by Multiply


To convert from inches to cm by multiplying:
  1. Click in a cell where you want to insert the converted amount.
  2. Type =cell to convert*2.54 (for example =A2*2.54)
  3. Press Enter.

Conversion formula is entered in column B:

Converting cm to inches by CONVERT function


To convert cm to inches using the CONVERT function:
  1. Click in a cell where you want to insert the converted amount.
  2. Type =CONVERT(cell to convert,"cm","in"). For example, type =CONVERT(A2,"cm","in").
  3. Press Enter.

Conversion formula is entered in column B: