My apologies.........I posted the result rather than the formula.....use
this...

=LEFT(A1,7)&"XXXX"

hth
Vaya con Dios,
Chuck, CABGx3




"CLR" wrote:

With the SSN in A1, put this in B1 and copy down.......then HIDE column A

123-45-XXXX

hth
Vaya con Dios,
Chuck, CABGx3




"Boo" wrote:

The document is for internal use. I need to change the social from appearing
as 123-45-6789 to 123-45-xxxx. Any help would be appreciated.

"Boo" wrote:

I need to change the format to have the last 4 digits appear as xxxx. How do
I do this?