Import/export with leading zero

Walter Vaughan wvaughan at steelerubber.com
Mon Feb 11 11:03:19 PST 2008


Richard Kreiss wrote:

>Using the following for export of a csv file with 2 fields having leading zeros.  On import to Excel, the zeros are dropped.
>
>When viewed with a text editor, the field is quoted "03001" but when opened, Excel drops the leading zero.
>
>Any suggestions as to what I am doing wrong?
>  
>

Is your google broken?
http://www.google.com/search?q=excel+import+leading+zeros

Third result is probably most helpful...

--
Walter



More information about the Filepro-list mailing list