Versions Compared

Old Version 3

changes.mady.by.user (OLD ACCOUNT) Erin Nettifee

Saved on

compared with

New Version 4

changes.mady.by.user (OLD ACCOUNT) Erin Nettifee

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. 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.
  2. 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).
  3. In column C, use TEXT to transform the number into a string with leading zeros

    Image Added
  4. in Column D, concatenate column A and Column C to create the desired barcode format:

    Image Added

  5. Finally, copy / paste just the values from column D into Column E, so that staff can copy/paste the barcode without the formula reference.

...