date/time

  • Thread starter Thread starter Help with Excel date/time formats
  • Start date Start date
H

Help with Excel date/time formats

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?
 
Back
Top