Incorrect Date formatting

D

dionne_w

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!
 
C

CyberTaz

IMHO, you don't need info from another website as much as you need to type
your dates correctly. Enter the date as 2/2/2002 or 02/02/2002 or use - in
place of /, but not just the 02022002 as indicated in your post.

Hope this Helps |:>)
 
Top