View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Aditya Aditya is offline
external usenet poster
 
Posts: 54
Default custom validation with number & text

how can i write formula for custom validation for a cell like this.

first 3 digit shoulg be a number, next digit should be a text then next 6
digit should be number.

e.g. 126P151008

thanks in advance