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?

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

"smithshouse" wrote:

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?

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?

In article ,
smithshouse wrote:

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?

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.
--
David Biddulph

"smithshouse" wrote in message
...
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?