Date formatting - Enter #'s to = formatted date

When entering dates, how do you format the column so that
you can enter just the numbers of the date (i.e. 100603)
and have it appear as "10/06/03" with the dashes. I've
tried using "custom" under formatting cells, but that
doesn't work. I've also tried using "tools"
and "autocorrect," but that only works for the specific
date you enter, and not any date.

You need VBA for that, a possible solution is here

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

--

Regards,

Peo Sjoblom


"Lisa" wrote in message
...
When entering dates, how do you format the column so that
you can enter just the numbers of the date (i.e. 100603)
and have it appear as "10/06/03" with the dashes. I've
tried using "custom" under formatting cells, but that
doesn't work. I've also tried using "tools"
and "autocorrect," but that only works for the specific
date you enter, and not any date.