Formatting Dates in Excel

S

smithshouse

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?
 
J

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?
 
D

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.
 
Top