I understand the formula but if I put it into a cell, how do I get the SSN
into the cell - if I paste it, it removed the formula.

Cheri

"dlw" wrote:


=CONCATENATE(LEFT(A1,3),MID(A1,5,2),RIGHT(A1,4))


"Doug Kanter" wrote:


"Cheri" wrote in message
...
I am trying to format a column of SSNs keeping any zeros in front and
dropping the hyphen. Can someone help me with this extra formatting?
Cheri

What going to be done with these numbers after they're formatted this way?
That could be a factor in how you achieve your goal.