You can't do it just by format.
--
David Biddulph

"Cathy C" wrote in message
...
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