LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
How do I get the zeros to show up in the beginning of a number? cmreisner Excel Discussion (Misc queries) 6 September 15th 05 12:59 PM
Array Formulas take waaaay too long... belly0fdesire Excel Worksheet Functions 7 August 8th 05 10:11 PM
Arrays Take too long. VERY HARD QUESTION. my head hurts : / belly0fdesire Excel Worksheet Functions 1 August 6th 05 12:47 AM
Zero at the beginning of a number Zeros at the front of numbers Excel Discussion (Misc queries) 4 April 11th 05 02:58 PM


All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"