Could be, but then I bet the non-ambiguous date format would show that as an
error right away. And I bet David's data|validation rule would catch that.

Bob I wrote:

i wonder if he meant 20081 not being a valid year?

Dave Peterson wrote:

I think you should allow the users to enter the date in any format that's
valid.

But you can format the cell anyway you want--but I would use an unambiguous
format so that it's easy to verify the dates.

jvq wrote:

How can I keep the mm/dd/yy format to display an error or message when other
users enter the wrong date: ie 12/31/20081?



--

Dave Peterson