Thread: Validation on cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dungan dan dungan is offline
external usenet poster
  
Posts: 411
Default Validation on cell
try placing the following formula in the "formula" section of the data
validation dialog box.

=AND(LEN(A1)=8,NOT(ISNUMBER(VALUE(RIGHT(A1,1)))))
Reply With QuoteReply With Quote