Looking for macro or script to change a format on excel column

Hello Experts,

I have an excel file with two columns both columns have contact numbers and they are populated.

I want to change the format of the contact #s to +1-(xxx)-xxx-xxx-xxxx.

I want to know if there is a function in excel that can change the format on these two columns, or if there is another way I can do it.

Any assistance in this will be helpful.

Thank you.
LVL 5
SR ZakNetwork Solutions Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
You will have to show the current format. Better if you upload a file with a few lines of sample data.
dynamicweb09Commented:
Go to format cells > Number > Choose Custom > put '+1-(000)-000-000-0000' in Type : field

Joydip

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SR ZakNetwork Solutions Author Commented:
I can not get this thing working. I put the custom format and it is not work on the number that is already there and it does not format it.
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

SR ZakNetwork Solutions Author Commented:
Guys, I need help here.

I just spent over 2 hours updating the phone numbers in my excel file and BEFORE saving the phone numbers did show as +1-xxx-xxx-xxxx --> this is the format I used when editing. I closed the file and it asked me to save it and selected yes.

now what I don't understand is why this stupxx format is changed I took a snapshot to show you how it looks now.
excel-issue.PNG
SR ZakNetwork Solutions Author Commented:
I want excel to stop changing any numbers in the cells. Please help
Saqib Husain, SyedEngineerCommented:
As I had requested, please upload a sample "Excel" file for testing.
SR ZakNetwork Solutions Author Commented:
Neither of the suggestions worked but since some of you made the effort I will accept the cell formatting solution.
SR ZakNetwork Solutions Author Commented:
Did not resolve my issue. I had to use the formula to get it resolved.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.