And the URL is

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


Gord

On Sat, 03 Sep 2005 16:50:08 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Check out Chip Pearson's site for code to "quick-enter" times and dates in the
manner you ask for.


Gord Dibben Excel MVP



On Sat, 3 Sep 2005 14:35:32 -0700, "Helpless"
wrote:

I am trying to figure a way to type in a date in pure numbers such as 020104
and for it to show in the cell as the date 02/04/04 in this format.

Please help