I'm exporting our inventory into Excel to make re-ordering easier (that part is simple). My problem is there are a lot of UPC's that start with 0 (I have 15,000 items in this spreadsheet). The 0 does not come up when I export, it automatically disappears. The UPC's should be a total of 12 digits, but any that should have a 0 as the beginning number only end up as 11 digits. Is there a formula to add the missing 0's without having to go line by line and manually doing it? The UPC's are in Column A if that helps at all.