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?