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