If the first cell value in the column is seen by Excel to be alpha, it will force additional cells in that column to be alpha only. While creating your output file, prefix the at least the first value with a single quote. The single quote will usually not display on the screen and wouldn't require an edit later to remove an alpha char. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Brungardt Sent: Friday, January 26, 2007 12:29 PM To: [email protected] Subject: [Talk] .txt to .xls
I’m trying to find a way to convert text files with values that contain leading zeros into Excel files that will keep those leading zeros. I can manually do this via Excel’s Import wizard but really need to find a way to script it. Command line, VB, something other than manually! Is there any hope? Thanks! Paul Paul Brungardt Clinical Analyst HaysMedicalCenter PH: 785-623-2196 PG: 785-650-5989
