How to Convert Inches to MM in Excel Fast

Converting Inches to MM in Excel

Use the CONVERT Function

The CONVERT function can be used to transform the value from inches to millimeters. Follow the steps below to know how –

STEP 1: Enter the value in inches in column A.

STEP 2: Go to the adjacent cell where you want to display value in mm.

STEP 3: Type the function =CONVERT(A2, "in", "mm"). This formula will convert inches to millimeters.

STEP 4: Drag the formula down to the entire range of cells.

Use Simple Multiplication

You can also use simple multiplication to convert inches to mm. Follow the steps below to know how –

STEP 1: Enter values in inches in column A.

STEP 2: Enter values in millimeters in column B.

STEP 3: Enter the formula =A2*25.4. This multiplies the inch value by 25.4, converting it to millimeters.

STEP 4: Use the fill handle to drag the formula down.

Review the results to make sure that all calculations are consistent and correct.

 

Advanced Techniques

Automating with Excel Macros

Macros can be used to automate the conversion process. This will be useful when you are working with a large dataset to minimize errors and also save time. Follow the steps below to use a macro to convert inches to mm –

STEP 1: Activate the Developer tab by using the Excel option.

STEP 2: Click on Record Macro in the Developer tab. Then, manually convert inches to mm by using the formula =A2*25.4.

Stop the macro once recording is completed.

STEP 3: Go to Macros and click Edit to make any changes if required.

STEP 4: Insert a button and then assign the created macro to that button.

STEP 5: Press the button to run the macro.

 

FAQs

How to convert the inches to mm?

You can convert inches to mm by simply multiplying the inch value by 25.4. This is because one inch is equal to 25.4 mm,

How to handle errors during conversion?

• First, check the formulas for any typing mistake like the formula itself or unit codes.
• Make sure that the correct cell references are used.
• Check the compatibility of the formula with the Excel version you are using.
• Use error checking tool to spot and fix errors.

Which units can be converted using CONVERT function?

The CONVERT function can transform different units of measurement, like –

• Length – mm, cm, inch, meter, feet
• Weight – kg, pounds, grams
• Temperature – Celsius, Fahrenheit, Kelvin
• Area – sq m, sq ft
• Volume – litre, gallon
• Time – hours, minutes, seconds

In which Excel version can you use the CONVERT function?

The CONVERT function works on Excel 2007 and all newer versions. It is available in Microsoft, Mac, and Excel Online.

How to CONVERT mm to inches in Excel?

You can use the CONVERT function to transform millimeters to inches. The formula should be =CONVERT(A1, “mm”, “in”).