If it is because your leading zeros are dropping off and leaving you
with a shorter string try

=LEFT(B4,LEN(B4)-1)

What format are your social security numbers in?


R


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=392746