Export number with leading zero to Excel

Robert Haussmann haussma at nextdimension.net
Wed Nov 29 15:27:42 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.
> 

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.



More information about the Filepro-list mailing list