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.

2 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums