Okay, I understand that Excel is thinking the number I am putting in (060806)
is a serial number for the date of 03/19/69. Is there a way to make it do
what I want. i didn't see it on www.cpearson.com/excel/datetime.htm

"Tory" wrote:

I formatted column for date, ie mm/dd/yy

However, when I enter in 060806 I get 03/19/69

I want to see 06/08/06. What is wrong?

I think it is making some sort of calculation.