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

Hi,

I am trying to add validation that willl do the following:

1. Prevent duplicate values being entered into a cell.
2. Only allow a 10 digit number being entered into a cell.

I know how to add these methods individually, but is it possible to set both
validation principles together on a cell or range of cells?

I would be most grateful for any help provided.

Many thanks,

John.