Three packages each weigh 1.24 kg. If your export displays each line with one decimal place, a reader may add the visible values and ask why the total says 3.7.

Round the measurement total if the underlying weights are authoritative

Put the three raw values in B2:B4. Use =ROUND(SUM(B2:B4),1). The raw sum is 3.72, which rounds to 3.7. A one-decimal display format changes what readers see while retaining the raw numbers.

Adding the raw weights first gives 3.72 and ROUND returns 3.7.

Illustrated final-total rounding. The sum keeps each source reading at full precision.

Round the line values if those values define the total

Use =ROUND(B2,1) in C2 and fill through C4. Then use =SUM(C2:C4). Three values of 1.2 give 3.6. Check both results against the rule for this export and label which precision the displayed total uses.

Rounding each line to 1.2 before adding gives 3.6.

Illustrated line rounding. Three small changes accumulate in the total.

Microsoft Excel instructions