User Tools

Site Tools


excell_import_leading_zeroes_2013

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
excell_import_leading_zeroes_2013 [2016/02/04 13:57 (8 years ago)] swindexcell_import_leading_zeroes_2013 [2021/11/24 09:26 (2 years ago)] (current) swind
Line 1: Line 1:
 ====== Preventing Leading 0's From Being Dropped When Opening a CSV File in Excel 2013 ====== ====== Preventing Leading 0's From Being Dropped When Opening a CSV File in Excel 2013 ======
-[[http://wws5.com/|{{http://wws5.com/images/topxxxgif-ani.gif  |Windward Software}}]] 
  
 +<note important>This document is also available as a FreshDesk Solution Article \\
 +</note>
  
 ===== Importing a Supplier’s Price List into Microsoft Excel ===== ===== Importing a Supplier’s Price List into Microsoft Excel =====
Line 25: Line 26:
 {{:excell:barcodes:capture3.jpg|}} {{:excell:barcodes:capture3.jpg|}}
    
- 5: In most cases you would set the delimiters to comma, and uncheck any others. But in some cases I have seen suppliers use Semicolon delimiters. If you are unsure, look at the preview window and between each piece of information you should see a delimiter. If you are unsure, just check each delimiter check box one at a time until you see the data in the preview window move into columns like the example below. Once your data looks like this, select next. + 5: In most cases you would set the delimiters to comma, and un-check any others. But in some cases I have seen suppliers use Semicolon delimiters. If you are unsure, look at the preview window and between each piece of information you should see a delimiter. If you are unsure, just check each delimiter check box one at a time until you see the data in the preview window move into columns like the example below. Once your data looks like this, select next. 
  
 {{:excell:barcodes:capture4.jpg|}} {{:excell:barcodes:capture4.jpg|}}
Line 47: Line 48:
 {{:excell:barcodes:capture8.jpg|}} {{:excell:barcodes:capture8.jpg|}}
    
- 10: Now you can safely resave your spreadsheet as a CSV.+ 10: Now you can safely re-save your spreadsheet as a CSV.
  
  
Line 53: Line 54:
 For information on loading your Excel Spreadsheet Back into System Five through a Data Load see: For information on loading your Excel Spreadsheet Back into System Five through a Data Load see:
  
-http://wiki.wws5.com/doku.php?id=dataload_after_excell_edit+http://wiki.wws5.com/doku.php?id=dataload_after_excel_edit
  
  
excell_import_leading_zeroes_2013.1454623034.txt.gz · Last modified: 2016/02/04 13:57 (8 years ago) by swind