Adding 0 or multiplying by one will do the same thing, my guess is that the
cell you copied had a different format


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"ClaireView" wrote in message
...
I don't know why I didn't think of multiplying by one when adding zero
didn't
work, but it did the trick! Thanks for all your help!

"ClaireView" wrote:

I have thousands of SSNs that imported to my Excel 2002 document without
formatting. I would like to change them from "123456789" to
"123-45-6789."
I researched this, and other postings here instructed me to create a new
column, format the new cells to "Special / Social Security Number," then
copy
the unformatted cells using Paste Special and choose Add. This doesn't
work.
The format still says it's in SSN format, but the numbers are still
123456789. Please, what am I doing wrong?!!