Is there a way to enter a date in this format: 04072004 and have excel produce this: 04/07/200
P pfox Apr 7, 2004 #1 Is there a way to enter a date in this format: 04072004 and have excel produce this: 04/07/200
M mzehr Apr 7, 2004 #3 Hi, Have a look at this site byChip Pearson: http://www.cpearson.com/excel/DateTimeEntry.htm
