G
Guest
Ok I am typing in a bunch of UPC numbers for my data sheet, It will be a
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.
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.