Use a customer format. Format Cells, on the number tab select Custom in
the category list at the left. In the text box labeled 'Type' enter the
format: 000000000, then click OK.

"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