i want to give a validation of date format in MS Excel.my date format is mm/dd/yyyy.if sombody enters a different format,it will show error message.i tried with Data–>validation–>
but if i give a date like 12345(with out ‘/’),it is automatically converting it to date.i don’t want this .how can i do this validation in Excel?