====== Preventing Leading 0's From Being Dropped When Opening a CSV File in Excel ======

<note warning>This document was written for Excel 2003 and 2005</note>

===== For more current versions of Excel refer to the following document =====

http://wiki.wws5.com/doku.php?id=excell_import_leading_zeroes_2013


====== Keeping The Leading 0's ======


To prevent leading zeros from being dropped when opening a CSV file in Excel, perform the following operation:

1: Open up a blank Excel spreadsheet

2: Go to the menu option DATA - Import External Data - Import Data


{{leadingzero1.jpg|}}

 
3: Browse to the data file you are trying to open. 


{{leadingzero2.jpg|}}

 
4: Then set to delimited, and select next.


{{leadingzero3.jpg|}}

 
5: Set the delimiters to comma, and uncheck any others. Select next.


{{leadingzero4.jpg|}}

 
6: Every column in the Data Preview Pane must be selected, and the column data format for each column must be changed to text. Then select finish.

 
{{leadingzero5.jpg|}}


You can either select existing worksheet or new worksheet.  Either one is acceptable.


{{leadingzero6.jpg|}}  


As you can see, the leading zeros are now present in the Excel worksheet


{{leadingzero7.jpg|}}



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


= Steve Wind Sept 19 2008 =

======
[[http://mywindward.wws5.com|{{  http://wws5.com/support/images/cust_support_banner_bottom.jpg  |myWindward}}]]