To show it as a SSN, there is a Special format for that in the formatting
menu. It will show it as ..

123-45-6789

To only show four numbers, either enter only four numbers, or use a formula
....

=RIGHT(A1,4)

... where A1 is the cell which houses the SSN.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"elli" wrote in message
...
Can anyone tell me how I can reduce a social security number to the last
four
digits?