I have the cell formatted to Date 03/14/01, however, when I type in 053106
and tab it displays as 05/24/45. Seems like there is a hidden formula but I
checked and the worksheet isn't protected and has no hidden formulas.
Suggestions please.