Format Phone Numbers Not Working ??


A

Al Franz

Using Excel 2003 and the Format Phone Numbers does not work. I have some
phone numbers as xxx-xxx-xxxx and others as (xxx) xxx-xxxx but can not get
them in all the same format. Excel does not seem to be smart enough? It
takes one or the other, should we be able to select the format?
 
Ad

Advertisements

A

Anne Troy

Likely, you need to first remove all the hyphens and parens in the existing
phone numbers. Then the formats will work. To get rid of that stuff, just
select the column, do a find for a hyphen and replace with nothing. Do a
find for left paren, replace with nothing, right paren, replace with
nothing. Then format the cells.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
 
Ad

Advertisements

F

Frank Kabel

Hi
have you entered the phone numbers only as numbers or have you included
brackets, etc. manually. In the latter case your numbers are stored as
'Text' and can't be changed by a number format
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top