excel_tips
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
excel_tips [2012/05/31 11:39 (12 years ago)] – cliff | excel_tips [2014/10/21 11:21 (10 years ago)] (current) – kevin | ||
---|---|---|---|
Line 10: | Line 10: | ||
[[http:// | [[http:// | ||
- | ====== Leading Zero Problem in MS excel ====== | + | ====== Leading Zero Problem in MS Excel ====== |
Microsoft Excel will remove leading zeros when manipulating data in the Comma Seperated Values (CSV) format. | Microsoft Excel will remove leading zeros when manipulating data in the Comma Seperated Values (CSV) format. | ||
Line 18: | Line 18: | ||
====== Excel Lookup to link data from 2 worksheets ====== | ====== Excel Lookup to link data from 2 worksheets ====== | ||
- | The following link will demonstrate how to merge to sheets of excel data that match using a unique value that is common to both sheets. | + | The following link will demonstrate how to merge to sheets of Excel data that match using a unique value that is common to both sheets. |
[[http:// | [[http:// | ||
Line 28: | Line 28: | ||
[[http:// | [[http:// | ||
+ | |||
====== 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. | ||
+ | |||
[[: | [[: | ||
+ | |||
+ | 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. | ||
+ | < | ||
+ | ="'"& | ||
+ | </ |
excel_tips.txt · Last modified: 2014/10/21 11:21 (10 years ago) by kevin