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
excel_tips [2012/05/31 11:47]
cliff
excel_tips [2014/10/21 11:21] (current)
kevin
Line 10: Line 10:
 [[http://​wiki.wws5.com/​doku.php?​id=videos:​export_to_excel1006091610|Exporting report data to Microsoft Excel]] [[http://​wiki.wws5.com/​doku.php?​id=videos:​export_to_excel1006091610|Exporting report data to Microsoft Excel]]
  
-====== 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. ​ To prevent this from happening there are some steps that can be used to preserve the leading zeros as demonstrated in the following article. Microsoft Excel will remove leading zeros when manipulating data in the Comma Seperated Values (CSV) format. ​ To prevent this from happening there are some steps that can be used to preserve the leading zeros as demonstrated in the following article.
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. ​ In the example we want category information to copy to the first sheet from the second using part number as our lookup value.+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. ​ In the example we want category information to copy to the first sheet from the second using part number as our lookup value.
  
 [[http://​wiki.wws5.com/​doku.php?​id=training:​howtousealookupinexcelforaddingcategories0909301511|Category Merge using Excel]] [[http://​wiki.wws5.com/​doku.php?​id=training:​howtousealookupinexcelforaddingcategories0909301511|Category Merge using Excel]]
excel_tips.txt ยท Last modified: 2014/10/21 11:21 by kevin