In another cell enter:

=DATE(RIGHT(A1,4),LEFT(A1,1),MID(A1,2,1))

NOTE this will only work with one digit months and days.

1112008 can be either January 11 or November 1
--
Gary''s Student - gsnu200777


"Té" wrote:

Everytime I enter 442008, which is supposed to be 4/4/2008, and I go to
format cells and try to convert it to a date format i get 2/6/1912. Why is
the computer giving me a different date? I would like to be able to enter
442008, and Excel automatically converts it to a date. The same thing
happens with the time when I type 8:25 and convert it to time I get 6:00.
Can you please tell me what I am doing wrong? Thank you!!!