View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Wonder From Downunder
 
Posts: n/a
Default How do I get Excell to recognise 0 at the beginning of a number?

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?