Thanks for your input. The reason I would enter the date as 111904 is that
it is much faster to enter the data using the numeric key pad. I would think
that most people who enter higher volumes of data would NOT want to be
entering the date as 11/19/04, unless you were getting paid by the hour. HA

"Peo Sjoblom" wrote:

Why would you enter a date like 111904? To me that is 111 thousand 904.
You need to enter dates in excel so excel knows they are dates! Thus you
need to use date delimiters like / or - etc or using VBA, thus either

11/19/04

or go here and use Chip's macro

http://www.cpearson.com/excel/DateTimeEntry.htm

Regards,

Peo Sjoblom



"Del" wrote:

Hello,
I am having a weird problem trying to format a cell to the date format
mm/dd/yy.

When I enter a date of 111904 it returns a formatted date of: 05/19/06

Can anyone help?

Thanks in advance!!!!

Del