How can I show only the last 4 digits of SSN ?

I

imc626

I would like to show the last 4 digits, but I do not want the cell to show
the complete SSN. Any "simple ideas"?
 
D

Dirk Goldgar

imc626 said:
I would like to show the last 4 digits, but I do not want the cell to
show the complete SSN. Any "simple ideas"?
Click to expand...

A controlsource of

=Right([SSN], 4)

maybe? Or

="***-**-" + Right([SSN], 4)
 
Top