Some Error that I can't figure out.


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.
 
Ad

Advertisements

D

Dave O

Format the barcode cells as Text. That will allow you to start off a
number with a zero, and if your numbers start to get long they won't be
truncated or converted to scientific notation.
 

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

Top