Validating a social security number

James ." Where cell A1 is the desired input location for the SSN, format cell A1 as either Special - SSN or Custom 000-00-000. The State sends all active and/or pending individuals from EIS and FSIS who do not have a validated code in the Master Client Index (MCI).(NOTE: The State does not select individuals whose SSI status is “Y”.) The first of the month run will validate ssns, post the validations to MCI, and will generate county reports.The middle of the month run will validate ssns, post the validations to MCI, but WILL NOT generate county reports.Research the individual to ensure that EIS contains the correct SSN, name, and date of birth.If you are successful in resolving the discrepancies in the vital data, update the incorrect data field(s) in EIS.

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.