Validation of date format in MS Excel

By Prince.Jose ·
i want to give a validation of date format in MS 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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums