i have range a2:a100 that i scan items into, the length of the barcode number
ranges from 10 - 20 digits. when i scan an item that is 20 digits long it
converts the last 5 digits to zeros. i tried formatting the cells to 20 zeros
but then if i scanned something with 10 digits it would add another 10 zeros.
i was thinking of a conditional formatting but i cant seem to get it. please
help
thank you in advance