Quote:
|
Originally Posted by The Wonder From Downunder
When using a barcode scanner, I am scanning UPC's into the Crtl F function to
find the UPC in a spreadsheet. When I scan the UPS it is readung it as a
whole number and not recognising the 0 at the beginning of the barcode. How
do I make Excell read it as a number with the 0 at the beginning?
|
If you are dealing with (for example) 6 digit numbers, and you need to see leading zeros, go to format cells custom. In the format definition box, replace the word "general" with 000000
Leading zeros will then be dosplayed