Hi,

We are a small food manufacturing company and I have made an Excel spreadsheet to keep track of our assigned UPC codes for all our SKU's.

I utilize the Azalea add-on to calculate the UPC-A 12th digit check number, which I have displayed in a 2nd column. The 1st column consists of the first 11 digits, but I have the cells in a custom format "# ##### #####" so that we punch in the numbers in sequence and it fixes the displayed format.

However, I just ran into a problem where I have a OEM brand packaging out in Canada where their UPC code starts off with a "0" as the first digit. Excel automatically gets rid of the "0", thus screwing up the check digit calculation. If I enter " '0 ##### ##### ", the spaces for some reason change the check digit calculation! I have to enter " '0########## " for the correct check digit to come out, but this makes it harder to reference the UPC code when we need to do so.

It's not a big deal right now since we only have 3 SKU's that are affected, but for future reference I thought I should consult the forum to see if anyone has any thoughts on this? Is there any way to simply disable whatever Excel process that removes the 0? (I tried searching online but all the results I see say to use the ' prior to the 0, or to format the numbers as text).

Thank you!