The format of the cell does not change. It appears the same and the size of
the column is large enough.

"Rick Rothstein (MVP - VB)" wrote:

Describe "no luck"... what does happen (that is, what do you see in the
cell)?

Rick


"ann" wrote in message
...
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?