i'm afraid you might have a slight problem.
In order for xl to recognize a date, it must be in a
format that it can recognize as a date.
with the cell formated at date, xl recognizes 101005 as
the date number and formats it to aug 31, 1927.

-----Original Message-----
I want to enter my date like this: 010105 abd have it
format it like this:
January 1, 2005. Help!
--
CLG
.