Social Security Number formatting
 

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

Social Security Number formatting
 

You don't. Excel is not a secure program; even if you were to have Excel
show the last 4 digits as XXXX it would be a simple matter to circumvent that
and display the whole SSN.

Dave
--
Brevity is the soul of wit.


"Boo" wrote:

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

Social Security Number formatting
 

Perhaps if you were to elaborate as to your needs and intentions, someone
could offer some alternatives that might be acceptable.

Vaya con Dios,
Chuck, CABGx3



"Boo" wrote:

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

Social Security Number formatting
 

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?

Social Security Number formatting
 

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?

Social Security Number formatting
 

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?

Social Security Number formatting
 

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?

Social Security Number formatting
 

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?