Hi,
Don is correct, of course. But why? If you check your formula bar after
you type 3/09 you will see that Excel figured you ment 3/9/2008. Excel has
to guess what the 9 means - the month or the year, it goes for month and
assumes the current year. If you typed 3/32 excel would know this could not
be a day of the month so it would assume you wanted the first, 3/1/1932.