Entering Dates in Excel

John · Feb 12, 2004

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 · Feb 12, 2004

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