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