When I typed 072806 in an excel formatted date column it came up 5/01/2099.
The only way I was able to keep the dates I want is to actually type 7/28/06.
I do not usually type the / when entering dates in a formatted column.