Thread: How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell

I have a spreadsheet that has social security numbers (SSN) in a column. The
numbers are missing the leading zeros and the two dashes for the SSN format
(i.e. the number is XXXXXXXX instead of 0XX-XX-XXXX. If you look in the cell,
the you see only 8 numbers, but when you format you of course see the SSN
format...000-00-0000. I need to add the leading zero and then the two dashes
(this because I am transferring the numbers to another software package).

My data set is large..manual entry will take forever.

Any ideas are welcome.

See response in excel.misc

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Allan" <Allan@discussions.microsoft.com> wrote in message
news:BF21B6BB-A9C2-4F03-B363-32561F626B44@microsoft.com...
> I have a spreadsheet that has social security numbers (SSN) in a column.
The
> numbers are missing the leading zeros and the two dashes for the SSN
format
> (i.e. the number is XXXXXXXX instead of 0XX-XX-XXXX. If you look in the
cell,
> the you see only 8 numbers, but when you format you of course see the SSN
> format...000-00-0000. I need to add the leading zero and then the two
dashes
> (this because I am transferring the numbers to another software package).
>
> My data set is large..manual entry will take forever.
>
> Any ideas are welcome.
>