Software
Assuming that the phone numbers are all in one column...
To set them all to (xxx) xxx-xxxx :
Select the column by clicking on its header. With the column now highlighted, go to the Format menu at the top and select Cells.
On the Number tab, select 'Special' in the Catagory field.
To the right, select 'Phone Number' and click OK.
Now they will all be in the (xxx) xxx-xxxx format.
To set them all to xxx-xxx-xxxx:
Do the same as above, but select 'Custom' rather than 'Special' in the Catagory field.
Then type in ###-###-#### (using the pound symbol with dashes in-between) in the 'Type' field and click OK.
I hope this helps.
It is greatly appreciated if you tag useful responses as 'Helpful' by opening that post and clicking the 'Mark Helpful' button at the bottom. That way, people with a similar situation in the future will be able to quickly see what ultimately helped. Thanks.
by phj
Not sure how to get into a view where I can select the column? If this was exel ... no problem but it is Outlook 2003.
Thx for your help CaptBilly1Eye
Peter
Chalk it up to it being Friday :)
I thought you were referring to Excel. DOH!
Phone numbers in Contacts within Outlook 2003 that were imported as part of a list from an external source have been know to cause issues like you described. In that, once imported, the format cannot be changed.
Are the numbers that are affected originally from an imported source or were they added manually one at a time?
I know there are some limitations with Business Contact Manager in that lists and forms cannot be customized. I'm not sure this pertains, but it may be of interest: http://tinyurl.com/25uwwd
Perhaps someone here has another idea, but would it be possible to export your contact list to Excel or LotusNotes, make the changes and then import the contacts back into Outlook? Just a thought.
Let me know if this helps.
This discussion is closed to new replies.
Sort by Trending