excel_tips
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
excel_tips [2012/05/31 11:47 (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:// |
excel_tips.txt · Last modified: 2014/10/21 11:21 (10 years ago) by kevin