Phone Number Standardization
Phone Number Standardization
Is there a quick way of standardizing phone numbers? In every ward I've seen, there are always a bunch of phone numbers in (xxx) xxx-xxxx and xxx-xxx-xxxx formats, and it'd be nice to choose one version, or the other, with out having to manually find and change each phone number.
There's no way to do it in bulk -- you do have to change each number. But there is a technique that makes it pretty quick.ajames wrote:Is there a quick way of standardizing phone numbers? In every ward I've seen, there are always a bunch of phone numbers in (xxx) xxx-xxxx and xxx-xxx-xxxx formats, and it'd be nice to choose one version, or the other, with out having to manually find and change each phone number.
- In MLS, on the Membership panel under View and Update, choose Household Record.
- Choose the first household in the list.
- Select the Contact Information tab (or click Next)
- If the Primary Phone Number is already in your desired standard format, skip to step 8.
- Click the Edit link in the upper right corner.
- Enter the new phone number.
- Click the Save button (or hit Enter 4 times quickly if you find the keyboard to be quicker)
- Click on the blue right triangle (or hit F4) to go to the next household.
- Go to step 4 and repeat until you've done all the households.
- Mikerowaved
- Community Moderators
- Posts: 4508
- Joined: Sun Dec 23, 2007 12:56 am
- Location: Layton, UT
BTW, the Church has selected the xxx-xxx-xxxx format, so I would suggest changing everything to that.ajames wrote:In every ward I've seen, there are always a bunch of phone numbers in (xxx) xxx-xxxx and xxx-xxx-xxxx formats, and it'd be nice to choose one version, or the other...
So we can better help you, please edit your Profile to include your general location.
Mikerowaved wrote:BTW, the Church has selected the xxx-xxx-xxxx format, so I would suggest changing everything to that.
It has? I guess I missed that. That is not the format I use. I prefer the international format, especially since it is used by most businesses in our fair city, and by most members of our stake.
xxx.xxx.xxxx
- Mikerowaved
- Community Moderators
- Posts: 4508
- Joined: Sun Dec 23, 2007 12:56 am
- Location: Layton, UT
Last week the Church pushed the "801" area code down to all MLS PC's in our area because of a looming area code overlay that started this past Sunday. Every phone number that was xxx-xxxx was changed to 801-xxx-xxxx. To me, this indicated an endorsement for this format.
There is no rule stating phone numbers MUST be in this format, so until that happens, I guess you are welcome to store them as you wish.
There is no rule stating phone numbers MUST be in this format, so until that happens, I guess you are welcome to store them as you wish.
So we can better help you, please edit your Profile to include your general location.
Oh, ok. I see where that thought came from. I have been dealing with 10-digit local phone numbers for nearly 25 years now. [grin]Mikerowaved wrote:Last week the Church pushed the "801" area code down to all MLS PC's in our area because of a looming area code overlay that started this past Sunday. Every phone number that was xxx-xxxx was changed to 801-xxx-xxxx. To me, this indicated an endorsement for this format.
- Mikerowaved
- Community Moderators
- Posts: 4508
- Joined: Sun Dec 23, 2007 12:56 am
- Location: Layton, UT
Thanks for the input. Obviously, this only applies to the USA, Canada, and other countries and teritories with a similar phone number configuration.13thfloorrocks wrote:For what it's worth, I checked the Church's Style Guide and it does indicate that 000-000-0000 is the standard format.

So we can better help you, please edit your Profile to include your general location.
Probably principally those using NANP as their telephone numbering plan.Mikerowaved wrote:Thanks for the input. Obviously, this only applies to the USA, Canada, and other countries and teritories with a similar phone number configuration.
Is there another style guide besides the Newsroom style guide, which uses dashes for international numbers [000-000-0000], and parentheses for US numbers [(801) xxx-xxxx]? .grin.13thfloorrocks wrote:For what it's worth, I checked the Church's Style Guide and it does indicate that 000-000-0000 is the standard format.