Hi

take a look at Chip Pearson's site
http://www.cpearson.com/Excel/DateTimeEntry.htm


--

Regards
Roger Govier

"Help with Excel date/time formats"
t.com wrote in message
...
Is there a way to set up a cell with a specific date format such as
11/30/2007 in which all the person would havee to type is 11302007 and the
rest autofill?

Also is there a way to do the same with time and is there a way to have
the
date and time characters ( "/" ":" ) automatically appear when you
begin
typing in a cell?