Incorrect Date formatting

[Guest]

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!

 

[Jason Morin]

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

 

[Guest]

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 |:>)