Stop removing leading zeros
Our inventory system is ruined because we've just discovered that Excel removes leading zeros from barcodes (in fact leading zeros from all numbers) when you import or paste-in.
This is truly mind-numbing because...
1) You're running data - why would you ever do this?
2) You always discover this nonsense after the fact with is so frickin' painful.
For the love of God, why do this and why change stuff automatically with no user input or notification? Get it sorted.