If you find when you export a CSV file, open a CSV as an XLS doc, or happen to see the UPC's not listing in full, below are the steps you take to fix those corrupted UPC's.
1. Highlight the UPC column
2. Click Format-> Cells -> Number
3. Switch the Decimal places from 2 to 0
Voila! Your UPC's are no longer corrupt.