Try this one.........

=LEFT(A1,3)&"-"&MID(A1,3,2)&"-"&"XXXX"

Vaya con Dios,
Chuck, CABGx3



"Boo" wrote:

Added twist. The formula works great BUT my cell I'm referencing was
originally set up as text. I convert the text to numbers and reformat to SSN.
However, when I use the formula it does format it with last 4 digits
appearing as XXXX but it does not put in the dashes. Additionally, I cannot
reformat the cell with special formatting for SSN. The spreadsheet is given
to me with the numbers showing as text and cannot be delivered to me in any
other format. Any ideas on how to get the last 4 digits of a social security
number to appear as xxxx, and formatted with dashes?

"CLR" wrote:

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?