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?