Right I've been using excel to upload products for an epos system we're trialing in a shop I work at. I recently lost half my work as excel changed half the characters to 0's and I didn't notice. It said online it does this for cells with 15 or more numbers however the barcodes are 13 or less and it did it anyways.
So I've figured out I can change them to General format or Text and not lose the second half of the characters. However I do also lose the leading 0's found on some barcodes.
If I format it as text it changes a cell from 012345678910 to E+123HD01 etc rubbish.
I then have to double click on the cell to make it show as a number again.
Fine if I had a few products, but there are entire ranges (5k+ products) so I can't go through them all.
Is there another way of doing it?
If this doesn't make sense I can try and explain again. Literally had no idea excel could become this confusing.
I just want it to treat the cell as a number. Ie. I write in 0123456789 and it shows 0123456789. I don't want it to remove the leading 0's, and I don't want it to change the second half to 0's.... I just want it to show what I've entered. And I don't want to have to go through all the current ones clicking them to change them.
So I've figured out I can change them to General format or Text and not lose the second half of the characters. However I do also lose the leading 0's found on some barcodes.
If I format it as text it changes a cell from 012345678910 to E+123HD01 etc rubbish.
I then have to double click on the cell to make it show as a number again.
Fine if I had a few products, but there are entire ranges (5k+ products) so I can't go through them all.
Is there another way of doing it?
If this doesn't make sense I can try and explain again. Literally had no idea excel could become this confusing.
I just want it to treat the cell as a number. Ie. I write in 0123456789 and it shows 0123456789. I don't want it to remove the leading 0's, and I don't want it to change the second half to 0's.... I just want it to show what I've entered. And I don't want to have to go through all the current ones clicking them to change them.