Automatically convert phone numbers

[NamelessCreep]

Hi everybody, I am trying to paste some phone numbers in this format 123-456-7890 and I want it to appear as (123) 456-7890 automatically. Please help

[daffodil11]

1. First select the cells you're going to paste to.
2. Hit Ctrl+1 to bring up formats
3. Choose Custom
4. In the field, put: (000) 000-0000
5. Hit Okie Dokie
6. Paste the number values in
7. Profit

If that doesn't work, then you'll need to pull out the "-". You can select the cells, hit Ctrl+H and replace - with nothing and then it will look fine.

[NamelessCreep]

Thank you so much. I tried the format cells thing on my own but it didn't work because of the "-". Your suggestion with find and replace did the trick. Thanks again

[AlKey]

or you can do it by formula

="("&LEFT(A1,3)&") "&RIGHT(A1,8)

	A	B
1	123-456-7890	(123) 456-7890

[AlKey]

Thank you for the feedback!

Actually there is a native excel format for phone numbers under Special, but you would need to removed dashes from the numbers first.
A number like 123-456-5465 after dashes removed 1234565465 and then apply format.