Number of posts : 494 Location : Bentonville, Akansas, USA Company : Clorox Title : Planogram Development Manager Registration date : 2006-11-16
Subject: Convert UPC's to 13 Digit Mon Feb 05, 2007 4:55 pm
This will convert a column of UPC's that are not 13 characters long and change them to 13 digits. Assuming your UPC is in column A... =rept(0,13-len(A2))&A2
Rick Donckers Moderator
Number of posts : 10 Registration date : 2006-11-17
Subject: Re: Convert UPC's to 13 Digit Thu May 24, 2007 7:45 am
Another formula option to do the same task in Excel. Again, assuming your UPC is in column A... =TEXT(A1,"0000000000000")
sosoris
Number of posts : 1 Location : Bentonville Company : Conair Corporation Registration date : 2008-08-01
Subject: custom formats Thu May 21, 2009 1:19 pm
Another way to get a 13 digit UPC is to right click on the cell, go to "format cell", choose the bottom option "custom", clear out whatever is under "type:" and type in thirteen zero's. Then just copy it down your column. easy. This works well for creating a 4 digit store number column too.
Subject: Convert UPC's to 13 Digit 
Mon Feb 05, 2007 4:55 pm
