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!