Last 4 digits of SSN
If you want to keep the whole SSN number, but only display the last 4 digits for
security purposes, then don't do it.
Excel's security isn't made to protect things like this.
But you could have a macro that actually only keeps those final 4 digits--but
why bother--just have the user type in the last 4 digits.
Matt wrote:
Is there a way to have the user input their whole social security number and
have Excel only display the last 4 digits of their number? Can I do this as
a cell format or will this have to be done with a script. I tried the data
validation with text length equal to 4, but if the last 4 digits start with a
zero (0123), it gives an error because it doesn't recognize the zero as a
digit. I'm guessing there has to be a script attached to that cell that will
grab the last 4 digits. Any ideas would be great. Thanks in advance.
--
Dave Peterson
|