See Chip Pearson's site for event code to allow quick entry of dates as you
describe.

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


Gord Dibben MS Excel MVP

On Thu, 9 Aug 2007 02:04:02 -0700, jbergsli
wrote:

I'm lazy and when I type the date in a cell I would like to type 080807 and
have it dispalyed as 08/08/07. Any Ideas??