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