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

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!

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

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!

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

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

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!

--

Dave Peterson

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

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

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

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