BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-15-2008, 09:45 AM   #1 (permalink)
CrackBerry Addict
 
hyedipin's Avatar
 
Join Date: Jul 2007
Model: 9700
PIN: N/A
Carrier: T-Mobile 2001-2007, AT&T 8/26/07 ->
Posts: 640
Post Thanks: 7
Thanked 2 Times in 2 Posts
Default Format phone number display to include dash or space

Please Login to Remove!

Most of my contacts' phone numbers are 2125551234, so if I am just looking at the number and calling them on another phone, it is always difficult.
I noticed that some contacts are properly formatted like (212) 555-1234 and while others are 212-555-1234. I think it depends on outlook, since some of them came from sync.

How can I format all numbers to be displayed with (3) 3-4 format? Even if I can't do it on BB, is there an option to manipulate all numbers on outlook, then I can sync them back?
__________________
Z30, AT&T
Offline  
Old 02-15-2008, 10:29 AM   #2 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2007
Model: 8330
OS: 4.5.0.77
PIN: N/A
Carrier: Verizon
Posts: 39
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You could export your Outlook contacts to Excel, and then if you're good in Excel write either a macro or some if-then text formulas to make the changes before you import them back in. I'd make sure to back everything up first.
Offline  
Old 02-22-2008, 01:13 PM   #3 (permalink)
CrackBerry Addict
 
hyedipin's Avatar
 
Join Date: Jul 2007
Model: 9700
PIN: N/A
Carrier: T-Mobile 2001-2007, AT&T 8/26/07 ->
Posts: 640
Post Thanks: 7
Thanked 2 Times in 2 Posts
Default

No other way to do this? Isn't there a setting on BB to format all numbers certain way?
__________________
Z30, AT&T
Offline  
Old 02-22-2008, 01:30 PM   #4 (permalink)
Talking BlackBerry Encyclopedia
 
cjcarbone's Avatar
 
Join Date: Jan 2008
Location: New Jersey
Model: 8310
PIN: K PANTHER
Carrier: ATT
Posts: 224
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

in outlook, you can go into your contacts view, and just click where you want a - and enter it. takes a while, but i haven't found another way yet, other than when i enter it into my address book, enter it in that format first
Offline  
Old 02-22-2008, 02:53 PM   #5 (permalink)
BlackBerry Mensa
 
tsac's Avatar
 
Join Date: Mar 2005
Location: Others run out when we run in
Model: Z10
OS: 10.010219
PIN: No Pin just a Tack
Carrier: at&t
Posts: 8,300
Post Thanks: 43
Thanked 579 Times in 574 Posts
Default

I did a sync to outlook then deleted the address book entries in the BB. reloaded the outlook contacts after it was fixed in outlook. a bit much but it did work
__________________
If someone helps, tell them by clicking the Thanks button


9810 BES
Z10 on BES
9700 BIS
Offline  
Old 02-22-2008, 03:49 PM   #6 (permalink)
BlackBerry Master
 
djm2's Avatar
 
Join Date: Jul 2007
Model: 9780
PIN: N/A
Carrier: T-Mobile
Posts: 4,637
Post Thanks: 29
Thanked 12 Times in 12 Posts
Default

In Outlook XP, immediately to the right of any phone number (when you are in text entry mode for that phone number) there is a little button with the picture of a pencil inside the button/box. This can be clicked.

If you click on this a small dialog and formatting box will appear that asks you to check the phone number. You can specify the country, and it will do all of the formatting for you, including adding the country code for international dialing.
Offline  
Old 02-22-2008, 04:27 PM   #7 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jun 2005
Location: Mississauga, Ontario
Model: 8330
Carrier: Bell Mobility
Posts: 1,050
Post Thanks: 0
Thanked 0 Times in 0 Posts
Wink

Quote:
Originally Posted by hyedipin View Post
Isn't there a setting on BB to format all numbers certain way?
Nope; would have to edit each entry in one way or another. The suggestions above are definitly some of the quicker ways. I would consider the Excel spreadsheet suggestion to be the easiest for large groups of numbers.
Offline  
Old 02-22-2008, 04:40 PM   #8 (permalink)
BlackBerry Master
 
djm2's Avatar
 
Join Date: Jul 2007
Model: 9780
PIN: N/A
Carrier: T-Mobile
Posts: 4,637
Post Thanks: 29
Thanked 12 Times in 12 Posts
Default

Quote:
Originally Posted by markhutchison View Post
Nope; would have to edit each entry in one way or another. The suggestions above are definitly some of the quicker ways. I would consider the Excel spreadsheet suggestion to be the easiest for large groups of numbers.
Or, if he knows some other programming language, you could use that as well. Personally, I would probably do it in SAS, but that is like using a very large hammer on a very tiny tack.
Offline  
Old 02-22-2008, 05:36 PM   #9 (permalink)
BlackBerry Mensa
 
tsac's Avatar
 
Join Date: Mar 2005
Location: Others run out when we run in
Model: Z10
OS: 10.010219
PIN: No Pin just a Tack
Carrier: at&t
Posts: 8,300
Post Thanks: 43
Thanked 579 Times in 574 Posts
Default

I think you see it's not easy using any method. They all require a bit of time.
__________________
If someone helps, tell them by clicking the Thanks button


9810 BES
Z10 on BES
9700 BIS
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.