Export number with leading zero to Excel

Robert T. Repko (R Squared Consultants) rtr at rsquared.com
Wed Nov 29 18:15:32 PST 2006


Believe it or not at 11/29/2006 06:27 PM, Robert Haussmann said:
> > I am trying to export data to a comma delimited ASCII file for
> > importing into Excel.  I can export the data to a file but when I
> > open the file in Excel the leading 0 of any number is dropped.  In
> > Excel if I precede a number with an apostrophe (') when I am entering
> > numbers the leading zero appears but not the apostrophe.  If I
> > precede the number with an apostrophe during the export the
> > apostrophe appears with the number in Excel.
> >
> > How can I keep the leading zero when I open in Excel.
> >
>
>Robert--this can be done during the import process in Excel.  During
>step #3 of importing a text file, you should see a "Data preview" window.
>Click the column(s) of those columns in which you want to maintain
>leading zeros, and set the type to "text" (the default is "general").
>
>Bob Haussmann
>Tabor Children's Services, Inc.

Thanks Bob, that does keep the leading 0.  I would like to allow them 
to simply double click on the csv file to open it in Excel but this 
will probably have to do.
***************************************************************************
* Robert T. Repko - R Squared Consultants   |   Voice: (610) 253-2849     *
* Serving the Computing World for 20+ years |     Fax: (610) 253-0725     *
* Windows/Unix Networking, Cisco, Sonicwall |   email: rtr at rsquared.com*
* NJDOE Provider ID#: 763                   | Address: 4 Juniper Ave.     *
* SPIN: 143010681                           |          Easton, PA 18045   *
***************************************************************************



More information about the Filepro-list mailing list