How does the data come in, is it just 1234567890? If so then assuming your
data is in Col A and starting in A1, in b1 try

=TEXT(A1,"(000)000-0000")

Copy down, then copy all and paste special as values.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"RTP" wrote in message
...
I have a phone number coming in. I know I can change the format but I also
need to PHYSICALLY change the cell as well. The cell HAS to appear as...

(123)456-7890

It HAS to because I have to try and De-Dupe it through Access and run an
Unmatched query against it so that it attempts to match up correctly to
the
physical table wich is formatted as (123)456-7890.

Can someone help me out here???

Thanks!