Automatically convert phone numbers

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.