I have a contact list with my telephone #'s starting in H9. I have the cells
formated in this row with the special telephone format option; however, when
my data entry person enterred the data, she didn't realize this so now I
have some formatted (###) ###-#### which is the special excel format and
some are formatted like she enterred them, ### ### ####. Is there a way to
make all of them the same format as the (###) one?

Thanks for you help.