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.

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.

Illustrated precision check. The calculated value is approximately 0.3937.



