You still have to give excel an idea that you're entering a date.

You can type 01/01/08 and then excel will see it as a date and use the
numberformat that you gave.

If you really don't want to type those slashes, you can use an event procedure
like the one Chip Pearson shares he
http://cpearson.com/excel/DateTimeEntry.htm

Stuart Perry wrote:

Hi there
I'm using Excel 2002 with SP3 installed
I'm having a few problems with dates. I've formatted the cell to use a date
format of 14.03.01 but when I enter the date (by typing for example 010108)
instead of changing the data to 01.01.08 it changes it to 3.9.27.

Any ideas what I'm doing wrong, am I simply entering the data wrong?.

--

Dave Peterson