if you are you posting to an existing excel sheet, you shuold be able to
declare the column to be text before you add data to it. then the leading 0
will be there.
If you are just using that excel sheet later, I use a format$(cellnumber,
"000000") types VB statement to post the excel data to another app.
Hope it helps
Bruce Krigman
Business Information Systems
South Shore Hospital
55 Fogg Road
South Weymouth, Ma. 02190
781-340-8299
Paul Brungardt
<[EMAIL PROTECTED]
.com> To
Sent by: [email protected]
[EMAIL PROTECTED] cc
WORKSTATION.COM
Subject
[Talk] .txt to .xls
01/26/2007 12:29
PM
Please respond to
[EMAIL PROTECTED]
ATION.COM
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.
