How can I add dashes to social security numbers?

It's easy. Lets say the SSN is 123456789 and its in cell A1. In cell B1, type in the formula:

=REPLACE(REPLACE(A1, 4, 0, "-"), 7, 0, "-")

That will make 123456789 appear as 123-45-6789 in cell B1. A screen shot is below:



You can then copy that cell and paste special just the values. That will eliminate the function formatting and you will have just the number formatted with two hyphens.

The REPLACE function has as it's input fields:

REPLACE(old_text, start_num, chars, new_text)