Data validation can't control the format in which a data is entered. It
could ensure that a date is within a specified range, or that a valid
date is entered.

What validation did you use?

SBA22000 wrote:
I have a cell where user should enter a date in the format "mm/dd/yy" so I
formated the cell to do so. when user enter a diffrent date format, the OS
convert it the predifined cell formating. but when an illogical entry is made
no thing happends. does data validation allow me to do so and dispaly a
warning message and how can I do so?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com