Date Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cathy C - 22 Jan 2008 10:58 GMT

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

Reply to this Message

Pete_UK - 22 Jan 2008 11:56 GMT

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

> 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

Reply to this Message