Hello everybody, today I am going to tell you how to validate barcode manually using excel. Step1: Pick a Barcode Example: 0728987019203 Step2 : Put all individual digit in excel expect the last digit. Find bellow the Image for reference. Step 3: Repeat 1 & 3 Just Bellow of the Barcode digit. Watch the Image for reference Step 4 Multiple the Blue Digit to barcode (0x1, 3x7..) digit on bellow shell. Look Bellow Image for reference. Step 5 Sum the Multiple Values and Just minus the Next Round Figure Numbers (120 is the next round figure number of 117) If the Minus value Match the last Number of Barcode then IT’s a validate barcode. Watch Bellow for reference. Hope you will use this one.
Learn Advance E-Commerce Tricks for online webstores,amazon, Multichannel.eBay, amazon Store promotion tips.