Hi Ruthki,

Ok, I'll try that. And the format the social security number is 000-00-0000

Thanks.

Hernan


"Ruthki" wrote:


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