Change Format of Column to Phone Format

Hello, Does anybody know how to change the format for the entire Column A from row 2 on from this format 123-564-9876 to (123) 564-9876. I need this in a macro form. Thanks for your help.

Hi...

Try this..

Please Login or Register  to view this content.

Thank you, that works.