Use the custom format as described by ForSale in earlier reply

To limit input in the cell use Data Validation

Assuming you are using A1 for the phone number:
Click on A1
Give it the custom format of (###) ###-####
Now click on Data Validation
On the Settings Tab - For "Allow" choose Custom
For the "Formula" type: =AND(ISNUMBER(A1),LEN(A1)=10)
If you want instructions for the user to pop up when the cell i
selected, go to the "Input Message" Tab, check the box for "show inpu
message when cell is selected" and type in a Title and Message
Click on the "Error Alert" Tab and give a title and message that yo
want for the error window which will pop up if the user fails to inpu
10 digits

Click O

--
Cutte
-----------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...nfo&userid=984
View this thread: http://www.excelforum.com/showthread.php?threadid=50959