Excel CSV identifier practice — expected result

This is fictional practice data. Treat CustomerCode, ZIP, and Reference as text.

Order  CustomerCode  ZIP    Reference          AmountUSD
O-201  000123        02108  12345678901234567  48.00
O-202  000124        10001  12345678901234568  75.00
O-203  000125        94107  12345678901234569  36.00

Checks:
- Exactly 3 data rows.
- First ZIP is 02108, not 2108.
- All three 17-digit references retain distinct final digits 7, 8, and 9.
- AmountUSD is numeric; 48 + 75 + 36 = 159 USD.

If identifiers changed, reopen the untouched source CSV and correct the
type detection steps before loading. Formatting damaged numeric cells as
Text later does not reconstruct missing digits.