Maggie Hidalgo
[EMAIL PROTECTED]Sr.
Applications Analyst, MIS
Riverside Health Care System, Inc
Work: (914)
964-4518
Fax: (914) 964-4310
----- Original Message -----
Sent: Wednesday, March 31, 2004 11:37
AM
Subject: [Talk] Zero Filling a
field
Greetings all,
I'm
reading data from a spreadsheet and although the column is formatted correctly
in Excel for a social sercurity number, the data station drops the leading
zeros. So 005112222 becomes 5112222.
Does
anyone know how to zero fill the field when the number of 0's will be
variable?
Many
thanks!
Denise
Denise Morrill
Clinical Systems Analyst
Spring Harbor Hospital
175 Running Hill Road
South Portland, ME 04106
207.761.2265
[EMAIL PROTECTED]
CONFIDENTIAL
NOTICE: This email message, including any attachments, is intended only for
the use of the
intended recipient(s) and may contain information that is
privileged, confidential and prohibited from unauthorized disclosure under
applicable law. If you are not the intended recipient of this message, any
dissemination, distribution or copying of this message is strictly prohibited.
If you received this message in error, please notify the sender by reply email
and destroy all copies of the original message.
Spring Harbor
Hospital Maine's Mental Health Network