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.
Comments
Post a Comment
Thanks For Your Valuable Comments.