How do I get Excell to recognise 0 at the beginning of a number?

G

Guest

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?
 
G

Guest

I'm not familiar with the barcode scanning, but in order for Excel to see a
leading zero on a number the cell must be formatted as TEXT.........

hth
Vaya con Dios,
Chuck, CABGx3
 
G

Guest

format the cell as text, or like this

00000

a cell with the format above that contains 123 will show as

00123

So just put as many zeros in the format as the UPC has digits.
 
E

ExcelPower

If your number is "096754" use "'096754" that is use >>>>>> ' <<<<<
before Zero hence excel will recognise it. " ' " this is one solution
or other is as said by others change the format of cell.

with regards

Excel Power
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PC often crashes, at the beginning or after pixels appear 3
Add leading #'s to a value 1
in 2003 i have 0 text file conrt to 2007 number 1
How to keep the zero on left without disappearing like 01234 3
How do I stop Excel from dropping leading zeros? 9
How do I format cells to show the number 0 as first number in seri 2
How do I display an insignificant 0 at the beginning of a number 2
Zeros at the first of the number 8

Top