Are you sure that you haven't put in =11/16/09 (in other words 11 divided by
16 then divided by 9)?
If so, get rid of the = sign.
--
David Biddulph

"Clark" wrote in message
...
When I type in a date field in my excel file the date "11/16/09" it is
displaying 00-Jan-00 instead of 16-Nov-09. Why is this happening??

Thanks!