Are they numbers, displayed with a special format, or are they text strings?
--
David Biddulph

"Rick" wrote in message
...
I have a colume of phone numbers formatted as follows (123)123-1234.
However
I need a formula to make a new colum exchanging the format to
123-123-1234.
Is there a way to do this? thanks