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

Reply via email to