There ae two ways:

1. a helper column
2. VBA macro

If you are entering data in column A, then in B1 enter:

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

The VBA method does the same thing, but in place.
--
Gary''s Student - gsnu200765


"Cathy C" wrote:

I want to format a column of cells so that when 012208 is entered with the
numeric keypad, 01/22/2008 appears in the cell. So far, I'm getting
6/3/1933.

Thanks,
Cathy