Thread: Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Panchi Panchi is offline
external usenet poster
 
Posts: 6
Default Validation

How can I limit input of A1 to a specific date format i.e. dd.mm.yy

From cell A1, I would like to extract the month and display as mmm in cell A2

Thanks