Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Connie Martin
 
Posts: n/a
Default Data Validation

I want to validate a cell that it must have an 8-digit number put in it---no
shorter, no longer. No matter how I validate the cell it won't work unless I
select "text length". This is not to be text! It's supposed to be an
8-digit number! What gives? How does one validate this cell to restrict it
to just that? How can something so simple be so contrary?