Hi,

Im having a lot of problems with my barcoding system in excel, if someone could help me out that would be great.

question 1:
Any suggestions on how to generate barcodes real easy? the barcodes we are using are 17 chars long and since excel doesn't work with codes longer than 15 it gives me problems to create barcodes. I want to drag it down to add sequencing numbers but since that does not work i'm changing all end numbers by hand which is a lot of work and i'm pretty sure not the easyest way. Anyone has any suggestions?

example of barcode:

153915012700000001
153915012700000002
153915012700000003

Question 2:
I want to update my prices in my barcoding system but to do that i need to export all the current data first, than change the prices and import all the updated prices again.

The problem im having is when I export the data it comes up in a .csv file, the barcodes however are already changed to 1,2 E+17 numbers.
So I tried exporting them in a different way and now what i have is a list of 5000 barcodes but all with a ; after the barcode itself.

example:
153915012700000001;

The problem is I cant import those barcodes with the ; behind it. Everytime I use a macro, formula or the easy find and replace button all the barcodes change to the 1,2 E+17 numbers which i dont want. (you lose the last 3 numbers of the barcode and it changes to 000 when you rechange it to text format). How can I take out all the ;'s after all the barcodes without them changing to the short code??

Really hope you guys can help