JD

Chip Pearson has code for this.

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


Gord Dibben Excel MVP

On Thu, 14 Jul 2005 13:04:02 -0700, "JD" wrote:

Is there any way in Excel that I can format the Date so I don't have to type
any slashes between the month and day? In other words, I would like to be
able to type in 0714 press "enter" and have excel recognize that this is
07/14/2005 without typing in 07/14.

Any suggestions would be appreciated.

Thanks,