Question Locked

Validation of date format in MS Excel

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by absolutely

If it must be an error message, you'll need to use VB/VBA.

This discussion is closed to new replies.