View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maree
 
Posts: n/a
Default Reformat column of telephone numbers

I have a variety of formats in the one column of phone numbers. Some have
parentheses, some do not. I would like them to be all formatted the same way.
It doesn't work through format the cell, special. The other resolution
given assumes all formats are the same. What do I do with the parentheses on
some of the entries?
--
Maree