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