An equipment drawing lists dimensions in millimeters and your order form uses inches. Keep the source measurement and calculate the new unit in a separate column.

Convert a value you can verify

Label B Length (mm) and C Length (in). Put 25.4 and 63.5 in B2:B3. Enter =CONVERT(B2,"mm","in") in C2 and fill down. The expected results are 1 and 2.5 inches.

Two length examples use mm and in as the conversion unit codes.

Illustrated known-value check. Keep both units in the column headings.

Choose display precision separately

Try 10 mm and compare it with approximately 0.3937 inches. Formatting to two decimal places displays 0.39 while leaving the underlying calculation available. Use arithmetic rounding only if the later calculation requires it. If a result looks off by a factor of ten, verify the original unit.

Ten millimeters displays as 0.39 inches with two decimal places.

Illustrated precision check. The calculated value is approximately 0.3937.

Microsoft’s CONVERT function reference