But I don't think that gives the symptoms whch the OP reported.
--
David Biddulph

"Jan" wrote in message
...
On Nov 17, 7:53 am, Clark wrote:
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!

you could have a regional setting problem.

your default date format is not mm/dd/yy

Jan van Niekerk
accountant
South Africa