Are they really numbers just formatted as SSN's?
=INT(A1/100000)

Or did you enter them as text?
123-45-6789
=substitute(left(a1,5),"-","")



DonJackson wrote:

Truncate column of social security numbers to the first four digits.

--

Dave Peterson