View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Slot Slot is offline
external usenet poster
 
Posts: 1
Default Data validation - dates

Hi

I want the users of my spreadsheet to insert a date, formatted as
dd-mm-yy (06-09-07).

I don't want any other formats, e.g. ddmmyy, ddddmmmmyyyy etc.

How do i use data validation to ensure this?