The packing list needs weights with a unit beside them. Enter the numbers 1.5 and 2 in B2:B3, and use formatting to show the label beside each one.

Attach the unit in Format Cells

In Ulet select B2:B3, open Format Cells → Number → Custom, and enter 0.0" kg" as the Type. The cells should display 1.5 kg and 2.0 kg. Enter all inputs in kilograms or convert them before applying this label.

The custom code 0.0 followed by a quoted kg label applies to two numeric values.

Illustrated custom number format. The space is inside the quotes.

Check that the numbers still add

In B4 type =SUM(B2:B3). The underlying result is 3.5. Use the same format on B4 to display 3.5 kg. Click B3 and check that its formula bar contains a numeric value without the suffix. If the total misses a row, check whether its value was entered as text.

A SUM of numeric 1.5 and 2 displays 3.5 kg when the total uses the same format.

Illustrated calculation check with the unit applied to the total.

Microsoft Excel instructions