Date Format

[Cathy C]

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

 

[Pete_UK]

Hi Cathy,

you might find these notes from Chip Pearson to be just what you want:

http://www.cpearson.com/excel/DateTimeEntry.htm

Hope this helps.

Pete