G

#### Guest

couple hundred numbers. The UPC numbers are as follows

012569528628

027616149237

025192051029

012235111536

012569528734

012569508422

12569508439

86162180934

043396039490

043396603820

012569509023

012569509030

12569512429

12569512436

For some odd reason all the numbers without a zero are wrong. All of these

numbers need 1 number 0 in front of them. As for the other numbers I get a

little green arrow in the upper left corner of the cell. It tells me

Something about "Number stored as text" (This is the one that is

automatically highlighted when i click the error tag) it gives me a couple

other options such as "Convert to Number" "Help on this Error"(Gets me no

where) "Ignore Error" which seems to be the only thing that allows the number

0 to stay. If I do the convert to number it removes the number 0. How can I

set the entire cell column to leave the number 0 infront of the number. I

have spent 45 minutes now trying to figure this out. Thanks for any help you

can provide me.