Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

First Lady · 05-15-2009, 03:39 PM

I am running Excel 2007

I have a sheet with a ton of phone numbers.

Some are formatted:

(403)555-1234

and others

403-555-1234

I need them to all look like the second example without the brackets. I have tried the formatting, but nothing changes. Or all the formatting for phone numbers includes the brackets.

Any assistance would be greatly appreciated.

05-15-2009, 03:39 PM	#1
First Lady First Line Centre Join Date: Jun 2007 Location: Calgary Exp:	Any Excel experts....? I am running Excel 2007 I have a sheet with a ton of phone numbers. Some are formatted: (403)555-1234 and others 403-555-1234 I need them to all look like the second example without the brackets. I have tried the formatting, but nothing changes. Or all the formatting for phone numbers includes the brackets. Any assistance would be greatly appreciated.