Differences

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

--- excel_tips [2010/06/09 16:48 (14 years ago)] – andrew
+++ excel_tips [2012/05/31 11:47 (12 years ago)] – cliff
@@ Line 21: / Line 21: @@
 [[http://wiki.wws5.com/doku.php?id=training:howtousealookupinexcelforaddingcategories0909301511|Category Merge using Excel]]
 ====== Excel programming to delete specific character ======
@@ Line 27: / Line 28: @@
 [[http://wiki.wws5.com/doku.php?id=faq:remove_character_excel_routine|Delete specific character 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]]
+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>