Differences

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

--- excel_tips [2012/05/31 11:39 (12 years ago)] – cliff
+++ excel_tips [2012/05/31 11:47 (12 years ago)] – cliff
@@ Line 28: / 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>