Try this in a "helper" column:

=TEXT(A1,"000000000")

To retain your leading zeroes.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Claire View" wrote in message
...
I exported some data from an Access database. The Social Security Numbers
are in this format: 123-45-6789. I would like to change them all to
123456789.

I've tried creating a Custom Format and formatting the cells, but nothing
changed. Tried setting the format of a new column, then cutting and
pasting
or Paste Special into the new cells, but it keeps the old formatting. Is
there an answer?