Excel Changes the Last Digit to Zero: Keep Long IDs Intact

Synthetic example for https://csv.jhsoftlabs.com/guides/excel-long-numbers

Import A1:C5 with case_id and product_id as Text and stock as a number. All four product IDs must match the original strings exactly; their lengths are 15, 16, 16 and 16. Stock remains 2, 12, 5 and 7, totaling 26. The two IDs ending in 3456 and 3457 remain different.

Read the guide for interpretation and application-specific steps. Preserve your own source files.