How do I enter a date typing 040906 and have it appear 04/09/06? I

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stover - 11 Sep 2006 21:52 GMT

I would like to format a cell so that I can just type in the numbers in a
date and have the cell display the date with the forward slashes added
automaticly! Example type in only 040906 and have Excel display 04/09/2006
in the cell.

Reply to this Message

Gord Dibben - 11 Sep 2006 22:28 GMT

You cannot format a cell to do this.

Chip Pearson's site has event code that will look after the change as you enter
the numbers.

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

Gord Dibben MS Excel MVP

>I would like to format a cell so that I can just type in the numbers in a
>date and have the cell display the date with the forward slashes added
>automaticly! Example type in only 040906 and have Excel display 04/09/2006
>in the cell.

Reply to this Message

Stover - 12 Sep 2006 13:29 GMT

Gord
Thank you very much for your quick response. I will not be frustrated now
and accept the fact that I can't format the cells like I wanted.
Stover

> You cannot format a cell to do this.
>
[quoted text clipped - 9 lines]
> >automaticly! Example type in only 040906 and have Excel display 04/09/2006
> >in the cell.

Reply to this Message

Pete_UK - 12 Sep 2006 13:44 GMT

What you can do is to enter the dates into a column in the format you
wish, and then in another column a formula can convert what you type
into a proper date. At the end of data entry you can fix the values and
use them to overwrite the value you typed in.

Hope this helps.

Pete

> Gord
> Thank you very much for your quick response. I will not be frustrated now
[quoted text clipped - 14 lines]
> > >automaticly! Example type in only 040906 and have Excel display 04/09/2006
> > >in the cell.

Reply to this Message

Rate this thread: