Incorrect Date formatting
 

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!

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

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

"dionne_w" wrote:

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!