Entering dates without slashes

[Bob Spencer]

How can I enter dates in month day year, example 102507 and have the slashes
entered or have Excel recognize the data as a date field. I want to be able
to enter dates faster, is the bottom line.

 

[Bernie Deitrick]

Bob,

Visit

http://www.cpearson.com/excel/DateTimeEntry.htm


HTH,
Bernie
MS Excel MVP

 

[JE McGimpsey]

See

http://cpearson.com/excel/DateTimeEntry.htm

 

[Gord Dibben]

Try the QDE add-in from Bob Phillips' site.

http://www.xldynamic.com/source/xld.QDEDownload.html

Ot the quickentry code from Chip Pearson's site

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP