I have a long column of phone numbers. I need to put all the numbers into (xxx) xxx-xxxx format.

Currently they are in three different formats.
1) xxx-xxx-xxxx
2) xxxxxxxxxx
3) (xxx) xxx-xxxx

Thank you.

Gene