User Tools

Site Tools


excel_tips

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
excel_tips [2012/05/31 11:39]
cliff
excel_tips [2012/05/31 11:47]
cliff
Line 28: Line 28:
  
 [[http://​wiki.wws5.com/​doku.php?​id=faq:​remove_character_excel_routine|Delete specific character in Excel]] [[http://​wiki.wws5.com/​doku.php?​id=faq:​remove_character_excel_routine|Delete specific character in Excel]]
 +
  
 ====== Barcode Fixing in Excel ====== ====== Barcode Fixing in Excel ======
 +Sometimes you may need to fix up barcodes without a check digit. This excel routine can help with this problem.
 +
 [[:​faq:​barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel]] [[:​faq:​barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel]]
 +
 +Tip: placing a single quote (') into the front of a barcode might help prevent problems where excel converts it to a number and you lose leading 0's. Here is a sample formula for excel that will add a single quote (') to the start of your barcode field. It assumes the barcode is in column A and we are setting up the formula on row 2.
 +<​code>​
 +="'"&​A2
 +</​code>​
excel_tips.txt ยท Last modified: 2014/10/21 11:21 by kevin