Format Telephone Cell Range
 

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.

Try using the Format Painter in the Standard Toolbar

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Victor Costello" wrote in message
t...
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.

Ctrl+H change " " to ""
make sure all are formatted as you want

Select an empty cell, copy it (ctrl+c)
Select the column
Edit, Paste special, add

The above is to match what you asked for, but since an area code
is now a required part of dialing, I would suggest using TEXT
instead of numbers and to use hyphens i.e. 514-555-1212
instead of (514) 555-1212 then you can handle any phone
number anywhere in the world. You can then even include extension
numbers.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Victor Costello" wrote in message t...
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.