1 cm = 0.3937 inch and 1 inch = 2.54 cm. Use a simple formula or the CONVERT function
1. First, to convert from centimeters to inches, divide by 2.54. The simple formula below does the trick.
2. To convert from inches to centimeters, multiply by 2.54.
3. You can also use the CONVERT function in Excel to convert from centimeters to inches.
Note: the CONVERT function has three arguments (number, from_unit and to_unit).
4. You can also use the CONVERT function in Excel to convert from inches to centimeters.