.... or =DATE(RIGHT(A1,2)+2000,MID(A1,3,2),LEFT(A1,2)), depending on how you
want your dates to be interpreted.
--
David Biddulph

"Gary''s Student" wrote in message
...
You can use a helper cell. If you enter 00807 in A1 as text, then in
another
cell enter:

=DATE(RIGHT(A1)+2000,LEFT(A1,2),MID(A1,3,2))

"jbergsli" wrote:

I'm lazy and when I type the date in a cell I would like to type 080807
and
have it dispalyed as 08/08/07. Any Ideas??