SOFTWARE       for filing of all 1097, 1098, 1099, 3921, 3922, 5498, 8027, 8966 FATCA Report, 8955-SSA, W-2G, and 1042-S IRS tax forms.
Quick Activation! Use the software today.
Order Online or Call
1099 software
(877) 380-6474 (480) 460-9311 (877) 543-6767

How can I add dashes to social security numbers?

You have the data in Excel. You import the data into the 1099FIRE software and the TIN's do not have dashes.

Question: How can I add dashes to the SSNs before importing?

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

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

That will make 123456789 appear as 123-45-6789. 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.

The REPLACE function has as it's input fields:

REPLACE(old_text, start_num, chars, new_text)

Please send an e-mail to with any feedback or comments about any of our products or services.