Question
January 14, 2007 at 11:17 PM
prince.jose

Validation of date format in MS Excel

by prince.jose . Updated 19 years, 7 months ago

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?

This discussion is locked

All Comments