I formated a group of cells to be dates seclecting the "date" category and
then selecting "03/14/01" type. But when I key 120199 in one of the
formatted cells it converts it to 02/02/29. When I key 120199 I expect it to
display 12/01/99. Why does Excell convert it? And how do I stop it from
doing so?