Input mask for changing a numeric to a Zero
 

I have SSN information (Nine digits) that I would like to be able to
mask the first 5 digits to Zeros. Simply put, I need this SSN
(123456789) to be masked to (000006789). That's all I need, and I
apologize for not finding my answer within this group as I'm really
pressed for time.

Thank You,

bd.

Input mask for changing a numeric to a Zero
 

Hello Bd420,

A1 = 123456789
A2 = "00000" & RIGHT(A1, 4)

Result in A2: 000006789

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=496852

Input mask for changing a numeric to a Zero
 

Assuming 123456789 is in A1, put this in B1

=TEXT(RIGHT(A1,4),"000000000")

"bd420" wrote in message
oups.com...
I have SSN information (Nine digits) that I would like to be able to
mask the first 5 digits to Zeros. Simply put, I need this SSN
(123456789) to be masked to (000006789). That's all I need, and I
apologize for not finding my answer within this group as I'm really
pressed for time.

Thank You,

bd.