validation for phone number

C

Candice

I want to limit the characters that the user can input in the phone number
field. Should I use conditional formatting for that?
Any help is appreciated,
Thank you, Candice
 
D

Dave O

When you say "limit the characters" do you mean you want to only allow
telephone numbers, or only allow numbers?

You can format the cell (on the menu, >Edit >Cells >Special >Telephone
number) so Excel will display a string of 10 numbers in (###) ###-####
format. Will that do it for you, or are you thinking of something more?
 
C

Candice

I want to limit the number of characters the user can imput: such as to
prevent a user from inputting more then the 10 digit phone number.
 
D

Dave Peterson

Can you stop them after they hit enter? (They might have typed too many
characters, but they'll get a warning.)

If yes, then
data|validation

And tell excel that you'll accept whole numbers between 0 and 9999999999.

Format the cell as a phone number to make it look pretty.
 
Top