Way to put a "1" in front of everybodies number in contacts

[cisco0910]

Is there an easiest way to put a one in front of everybodies number in your contact list? Manually would take forever.

 

[sam5828]

why? ya dont need to

 

[hookbill]

Is there an easiest way to put a one in front of everybodies number in your contact list? Manually would take forever.

I don't know of any. If I had to do it, I'd do it in gmail on line. 1 and copy paste it.

You looking for the 1 for Skype?

 

[keiichi25]

You don't really need the '1' in front of the numbers. Current US Cellphone technology assumes you are calling in the US and numbers with Area Codes will be considered 1+Number. If you only put in 7-9 digits (Which is the standard 7 Digits or some who put in a little more in their phone number), it presumes you are dialing a local area code number based on your cell tower, (I believe).

I know for PBX systems for companies, when you get T1 lines going into it, depending on who the provider is, you can set the system to ignore or require.

 

[Cyrus6001]

Export your contact from gmail into .csv format. Open that csv file in excel. Once in excel you can select the colum with the numbers and add the "1".

Anybody here good with excel? I know theres an easy way to add the digit, i just haven't had to do it in a long time. Theres some type of data formula you can run that will allow you to specify that you want to add to the data colum and where. So in your case you want to add a "1" before yout data string(i.e. phone numbers).
Then just import the csv back into gmail

 

[Cyrus6001]

Ok so its the Concatenate function
So take your list of phone numbers. Insert a column to the left of those numbers. fill each cell in the new column with a 1. The run the above function to combine both cells. And viola! all ur numbers now have a 1 in front of them

 

[ldimick]

Export your contact from gmail into .csv format. Open that csv file in excel. Once in excel you can select the colum with the numbers and add the "1".

Anybody here good with excel? I know theres an easy way to add the digit, i just haven't had to do it in a long time. Theres some type of data formula you can run that will allow you to specify that you want to add to the data colum and where. So in your case you want to add a "1" before yout data string(i.e. phone numbers).
Then just import the csv back into gmail

A1 contains the phone number
cell B1 would say ="1"&A1
Then copy the B1 column and do a Paste Special of B1 to A1 and replace the results ONLY. Then delete column B. Should work.

 

[Cyrus6001]

A1 contains the phone number
cell B1 would say ="1"&A1
Then copy the B1 column and do a Paste Special of B1 to A1 and replace the results ONLY. Then delete column B. Should work.

That works too.

 

[Corinacakes]

Is there an easiest way to put a one in front of everybodies number in your contact list? Manually would take forever.

There's a free app in the market called "contacts clean-up" that does this

 

[mikes]

If you're going to do it, do it right, and make it proper E.164 format by adding "+1"