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
- Dividing
- Multiplying
- CONVERT function
Converting cm to inches by Divide
To convert from cm to inches by dividing:
- Click in a cell where you want to insert the converted amount.
- Type =cell to convert/2.54 (for example =A2/2.54)
- Press Enter.
Conversion formula is entered in column B:
Convert cm to inches by Multiply
To convert from inches to cm by multiplying:
- Click in a cell where you want to insert the converted amount.
- Type =cell to convert*2.54 (for example =A2*2.54)
- 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:
- Click in a cell where you want to insert the converted amount.
- Type =CONVERT(cell to convert,"cm","in"). For example, type =CONVERT(A2,"cm","in").
- Press Enter.
Conversion formula is entered in column B: