View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SiH23 SiH23 is offline
external usenet poster
 
Posts: 48
Default Data Validation Query

Hi,

I would be most grateful if someone could offer some advice.

I need to set some kind of validation on columns to only except a 10 digit
number and nothing else. For example if a 9 or 11 digit number is added an
error message is displayed. Is this possible?

Kind regards,

Simon.