Is your SIN a 9 digit number that has special formatting to include the
dashes or is it text that already physically includes the dashes? If its the
1st case just format as text.

"kim" wrote:

I have a column in Excel with social security numbers and i need to make the
formatting so the number has no dashes in it. So for instance 111-11-1111,
should look like 11111111. Is there a quick way to format my column to look
like this??

Thanks

Kim