Thread: DATA VALIDATION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Aditya Aditya is offline
external usenet poster
  
Posts: 54
Default DATA VALIDATION
data in column B is of 9 or 10 or 11 or 12 digit.
In every case it contains alphabet "P" whereas others are digit.
e.g. 10P060509
125P695847

how can i check this through data validation?

Reply With QuoteReply With Quote