Data Validation

  • Thread starter Thread starter Jay Gustafson
  • Start date Start date
J

Jay Gustafson

Hello,

How can I force someone to type a telephone number in the correct format by using Data Validation?

IE: 555-555-5555 ###-###-####

If it is not entered in that formation, I don't want the cell to accept it.

Thanks,
Jay
 
Jay

Might be easier to format the cell as Special>Phone Number (###)###-#### or
Custom ###-###-#### then in DV use text length "equal to" 10

Gord Dibben Excel MVP
 
I first selected the desired cell range, then from the
drop-down menu: Format, Cells, Custom, then created a
custom number format as follows in the Type area:
###-###-####

After that, making sure the range was still selected,
Data, Validation. In the Allow tab select Custom, then
ensure one of the cells in the range that you applied the
custom formatting to is entered into the Formula box,
e.g. =A1

This worked for me, but there may be another way as well.
-----Original Message-----
Hello,

How can I force someone to type a telephone number in the
Click to expand...
correct format by using Data Validation?
 
This was perfect. Thank you.
Gord Dibben said:
Jay

Might be easier to format the cell as Special>Phone Number (###)###-#### or
Custom ###-###-#### then in DV use text length "equal to" 10

Gord Dibben Excel MVP
Click to expand...
 
Back
Top