Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Some Error that I can't figure out.
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i calculate 20% of a total figure | Excel Worksheet Functions | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
how to type a minues figure | New Users to Excel | |||
Timesheet - I can't figure out how to do this! | Excel Worksheet Functions | |||
excel to figure miles per gallon | New Users to Excel |