displaying last 4 digits of social security numbers

[sclinden]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

Hi. Seems like this should be an easy one, but I sure can't figure it out.

I have a database of names and social security numbers that was sent to me. I need to redistribute the database but only want the last 4 numbers displayed or the first 5 numbers as Xs (i.e. XXX-XX-1234) without having to re-key in every entry. Is there a way to have the cell change the display?

Thank you!

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

Hi. Seems like this should be an easy one, but I sure can't figure it out.

I have a database of names and social security numbers that was sent to me. I
need to redistribute the database but only want the last 4 numbers displayed
or the first 5 numbers as Xs (i.e. XXX-XX-1234) without having to re-key in
every entry. Is there a way to have the cell change the display?

Thank you!

Your best bet is to use another column that displays what you want. Then
hide the original column. In the new column use a formula that looks
something like: ="XXX-XX-"&right(a1,4)

 

[sclinden]

Bob,
That worked perfectly! Thanks for the quick reply and solution!

-sclinden