That format would be just fine, however I can't change my existing data to
that format.

I have tried to hi-light the entire column, then right click and select cell
format, I then change the format to the phone number format and hit ok.
Nothing happens. The numbers all remain the same......

"RagDyer" wrote:

If you could live with this format:
(123) 456-7890

There's a built in phone number format under:
<Format <Cells <Special <PhoneNumber
Where you can convert the existing numbers in place, without having to use
an additional column.
--

HTH,

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

"MarkT" wrote in 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!