Date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cathy C - 23 Jan 2008 03:09 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

fredg - 23 Jan 2008 04:16 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

Cells?
Are you using Excel?
You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Cathy C - 23 Jan 2008 04:23 GMT

Sorry about that. I posted it to the Excel forum early this morning, but it
never showed up. Missed again. I'll try one more time.

> > 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
[quoted text clipped - 11 lines]
> are using. I would suggest you include your Windows and Office version
> number in the message.

Reply to this Message