I am trying to do the opposite for what everyone else has been asking for
help in resolving a phone number issue.

I want to key in each cell nine digits and have it automatically format into
a phone number format as shown in my subject. I have gone to
Format/Cells/Number to select the Special Type for Phone numbers, no luck.
The won't change. Then I thought I would create a custom format of both
###-###-#### and (###)###-####, once again no luck. I have tried everything
short of pulling out my hair. Does any one have any suggestions?