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?