Export number with leading zero to Excel
Robert T. Repko (R Squared Consultants)
rtr at rsquared.com
Wed Nov 29 15:12:20 PST 2006
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.
Any ideas gratefully appreciated.
***************************************************************************
* 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