Formatting Dates in Excel

[Guest]

When I try to enter a date in my spreadsheet such as 02022007 (02/02/2007)
and hit enter it inputs 09/12/1956???? I have no idea where this value comes
from. Is there a place where values for formats can be changed?

 

[Guest]

Dates must be entered as 02/02/2007 or 02-02-2007.

 

[JE McGimpsey]

The problem isn't formats, it's XL's input parser that can't guess when
02022007 is a date and when it's representing, say, $2,022,007.00.

You can use an event macro to change is behavior.

http://cpearson.com/excel/DateTimeEntry.htm


Note that your intent in your example (02/02/2007) is ambiguous -
mm/dd/yyyy or dd/mm/yyyy?

 

[David Biddulph]

As others have pointed out, you need to enter the date in date format, but
I'm worried about your Excel.
02022007 should give 24th January 7436, not 09/12/1956. 09/12/1956 should
come from 20798 or 20710, depending on your date formatting.