ssn="456789" format(ssn,"000000000") = "000456789"
ssn="123456789" format(ssn,"000000000") = "123456789"
Maggie Hidalgo wrote:
Hi Denise,
You have to text format the column.
Maggie Hidalgo [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Sr. Applications Analyst, MIS
Riverside Health Care System, Inc
Work: (914) 964-4518
Fax: (914) 964-4310
----- Original Message ----- *From:* MORRILL,DENISE <mailto:[EMAIL PROTECTED]> *To:* Boston Workstation Talk (E-mail) <mailto:[EMAIL PROTECTED]> *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
-- Neil Carman Director Technical Development Manigault & Associates LLC
http://www.m-allc.com Work: (805) 680-5601 Fax: (714) 968-5632
