Date is displaying 00-Jan-00 when I type in 11/16/09.

[Clark]

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!

 

[David Biddulph]

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.

 

[Dave Peterson]

In xl2003 menus:
Tools|Options|Transition tab
Uncheck all those lotus 123 settings.

 

[Jan]

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

 

[David Biddulph]

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

you could have a regional setting problem.