Your best chance is to make everything inot a number and then custom format
that number. To that end you want to do the following...

Find and replace all of the non numeric character including blank spaces
with nothing. When all of the non-numeric characters are gone your phone
number (which is now a text string) will become a number. Once that is done
then highlight the column and apply the following custom format to it (Format
- format Cells - Number - Custom)
(000) 000-0000
--
HTH...

Jim Thomlinson


"Jim" wrote:

I have a long column of phone numbers that I'd like to put in the same
format; I've tried Find/Replace and Special Formatting to no avail; the
numbers are similiar to this:

419-248-8000
(201) 567-8000
(201)307-4000
(215) 751-5000

I'm a very inexperienced user and not comfortable with Formulas, so consider
that in your response....

Any thoughts??

Jim