Number of posts: 429 Location: Bentonville, Akansas, USA Company: Clorox 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
Number of posts: 1 Location: Bentonville Company: Conair Corporation Registration date: 2008-08-01
Subject: custom formats Thu May 21, 2009 12: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
