Excel custom number format: add units without breaking SUM

Expense sheets and price lists often need a unit after the number: a currency name, "pcs", "kg". The...