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