View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default validation for phone number

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?