Either use the slashes or VBA code if you wish to enter 010101 as a date.

Chip Pearson has code at his site.

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


Gord Dibben MS Excel MVP

On Wed, 19 Jul 2006 10:01:14 -0400, RAPPEL
wrote:


hi, im sure this is a silly question, but its driving me nuts. i need
to enter a string of dates in a column. i want them to appear
01/01/2001. i formated the cells with the date format, but when i type
in 010101 it formates to really wierd things, like 08/12/1955. do i
have to put the slashes in, or is there a way for it to do it for me?

thanks