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))
--
Gary''s Student - gsnu200736


"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??