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