What do I need to do to properly enter a Date?

  • Thread starter Thread starter ND Pard
  • Start date Start date
N

ND Pard

I know this has got to be simple, and when I hear the answer I'll probably
kick myself.

When I type 1/1/2009 in a cell, why does it display 01/00/1900?

What can I change so this will work all of the time in Excel?

Thanks.
 
I would have swore I had checked that ... but when I checked it again, it was
checked.

Thanks "Bob I" for your help; it is appreciated.
 
You're welcome, have a great day!

ND said:
I would have swore I had checked that ... but when I checked it again, it was
checked.

Thanks "Bob I" for your help; it is appreciated.

:
Click to expand...
 
Back
Top