Problem formatting for phone number

[rutledj]

Can anyone tell me how to use the cell validation or some other method
to put the numbers entered in a cell in a proper phone number format?
(###) ###-####


Thanks,
Rut

 

[Dave Peterson]

Let your user type in the phone number (as a number).

Then use Format|Cells|number tab|Special|Phone Number.