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

 

Important:  This email and any attachments may contain confidential information 
subject to protection under the Federal Standards for Privacy of Individually 
Identifable Health Information (45 C.F.R. Parts 160 and 164).  If you or your 
organization is a “Covered Entity” under the above mentioned regulations, you 
are obligated to treat such information in a manner consistent with the 
regulations.  If it appears that this email was sent to you in error, (1) you 
are prohibited from utilizing or disseminating this email or any attachments; 
(2) please immediately delete it from your computer and any servers or other 
locations where it might be stored, and email this sender or call the Hays 
Medical Center Privacy Officer at (785) 623-2188 advising that you have done 
so.  We appreciate your cooperation.

Reply via email to