Hi Cindy

your cell is formated as DATE, try ti format it as a text to include 053106
or general to see 53106, note that the genderal will supress the left zero.

hope this helps,
regards from Brazil
Marcelo

"CindyLF1" escreveu:

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.