Entering Dates in Excel

[John]

Hi,

Is it possible to just enter 020304 in a cell and have
the date come out correctly or must I put -'s or \'s to
seperate the numbers

 

[Frank Kabel]

Hi John
without using VBA this is (AFAIK) not possible. Have a look at
http://www.cpearson.com/excel/DateTimeEntry.htm
for a VBA solution

Frank