What do you mean by "move the old number"?

Copy the column of numbers, select the formatted column,
and go to Edit Paste Special Value.

HTH
Jason
Atlanta, GA

-----Original Message-----
Greetings:

I would like to convert a column of telephone numbers
that are currently in
the format of: ########## to the format of: ###-###-####.

I have added a column next to the existing phone number
column with the new
format listed above, but when I move the old number to
the new number, the
format does not change. It will only change to the new
format if I manually
enter in each number.

Does anyone know how I could convert the existing
numbers to the above
telephone format?

Thanks in advance for your help!
.