On Thu, 17 Mar 2005 09:25:07 -0800, Fluffy from Wisconsin
wrote:

Hi All,
I have a listing of names, addresses, etc. in an Excel document. The
telephone numbers have been entered in several different formats:
123/456-1234, (123)345-1234, 123-455-1234. Is there a way to format the
column so that these numbers will all be displayed in the same format? If
so, please explain how. Thanks,
Fluffy from Wisconsin
Reading Teacher


In addition to the formula approach, you could also use a VBA macro.

To enter this macro, <alt-F11 opens the VB Editor.

Ensure your project is highlighted in the Project Explorer window, then
Insert/Module and paste the code below into the window that opens.

To use the macro, select a range of "phone-number" cells. Then <alt-F8 opens
the macro dialog box. Select FixPhoneNums and <Run.


--ron