...
- In an excel sheet, copy paste "CR" into column A all the way down to the end of the number of barcodes you are trying to create.
- In column B, type in the number and then use a formula to add 1 to the number all the way down (so you create the desired sequence).
- In column C, use TEXT to transform the number into a string with leading zeros
- in Column D, concatenate column A and Column C to create the desired barcode format:
- Finally, copy / paste just the values from column D into Column E, so that staff can copy/paste the barcode without the formula reference.
...