George wrote...
That works but it drops any leading zeros from SS# that start with zero !
....

You're importing this into Access. If the Access field type is text
spanning 9 characters, then in Excel the first step you need to
perform is applying the number format Text (that's its name) to the
column of SSNs, then [Ctrl]+H to display the Replace dialog, then
follow the other respondents' suggestions. If the Access field type is
number formatted with leading zeros, then there shouldn't be a problem
with Excel dropping the leading zeros.