You have to put in a date separator to get dates, such as

01/01/01

or

15/01/2004

--
HTH

Bob Phillips

"itqueen" wrote in message
...
The digits typed do not match the output, I wonder why.
I also tried to type 000000 and that defaulted to Jan1 1900.
then I input 010101 which results into 8/27/27 , for 8/27/1927. this
really baffles me, as I tried to Clear All to no avail.
thanks for your help