Validating a social security number
The United States is not the only country to use Social Security Numbers, but for demonstration purposes we will focus on validating U. This is because on June 25th, 2011, the Social Security Administration revised their assignment process to use a system of randomization that had the following changes : The previously mentioned "randomization act" made it significantly easier to use a mechanism such as a Regular Expression to handle validating Social Security Numbers.It is possible that SSA assigned more than one SSN to an individual.When this occurs, more than one validated SSN is returned by SSA and posted to MCI.However, when I copy the function into Data Validation it does not work. My ultimate goal is to have a user type the 9 digit SSN in a cell (no dashes), have data validation test to make sure it is numbers, length=9 and have it displayed ###-##-####. Thanks, James Dave, Thanks for the reply but it doesn't accomplish what I wanted.
Using the settings you suggested it doesn't recognize "0" as a leading number (when the SSN starts with 0), and it doesn't display an error message if you enter letters instead of numbers.
This report lists individuals from earlier discrepancy reports for which no action has been taken.