Check out both these sites; one offers a freely
downloadable Excel utility that convert various date
entries into date formats Excel recognizes. The other has
code you can use.

http://www.xldynamic.com/source/xld.QDEDownload.html
http://www.cpearson.com/excel/DateTimeEntry.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
When I type in a date using my number keypad (i.e.
02032002) for Feb 3,
2002, the date appears incorrectly in my cell. Using
this example, my cell
appears as 6/6/7463.

I have changed to the default "date" format both under
Format: Style and
Format: Cells.

I also emailed the spreadsheet to another party. They
can fix the cell to
read correctly, but when it comes back to me, it again
formats incorrectly.

I have not (purposefully) added any functions or "if"
messages to my dates,
as they are just simple date entries.

Any help would be very appreciated. Thanks!
.