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!