=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.