stockcountreport
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
stockcountreport [2008/09/21 18:55 (16 years ago)] – swind | stockcountreport [2021/05/11 21:46 (3 years ago)] (current) – [Generating the stock count for manipulation in Excel] plagrada | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Generating the stock count for manipulation in Excel ====== | ====== Generating the stock count for manipulation in Excel ====== | ||
- | [[http:// | + | |
+ | |||
+ | |||
+ | |||
Line 41: | Line 45: | ||
- The default type should be CSV format, which most programs including Excel can import. | - The default type should be CSV format, which most programs including Excel can import. | ||
- | - Give the file a name, and save it to your desktop, or any other location that will make it easy for you to | ||
- | find the file. | + | - Give the file a name, and save it to your desktop, or any other location that will make it easy for you to find the file. |
- | The file is now ready to import into Excel | + | The file is now ready to import into Excel. |
DO NOT OPEN THE FILE WITH EXCEL. The file must be imported, not opened, and all fields must be imported as text. | DO NOT OPEN THE FILE WITH EXCEL. The file must be imported, not opened, and all fields must be imported as text. | ||
Otherwise Excel will remove all leading zeros from your barcodes. | Otherwise Excel will remove all leading zeros from your barcodes. | ||
- | For mor information on this see the document on Preventing Leading 0's From Being Dropped When Opening a CSV | + | For more information on this, see the document on Preventing Leading 0's From Being Dropped When Opening a CSV |
+ | |||
+ | File in Excel.[[http:// | ||
- | File in Excel. | + | For information on loading your Excel Spreadsheet Back into System Five through a Data Load see: |
+ | http:// | ||
stockcountreport.1222048511.txt.gz · Last modified: 2008/09/21 18:55 (16 years ago) by swind