# 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

• Dividing
• Multiplying
• CONVERT function

### 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: